google2011 Posted April 26, 2012 Author Report Posted April 26, 2012 [quote name='Help veerudu' timestamp='1335452556' post='1301690754'] i have a sql query.....both joins and sub queries same ahaaaa? nenu aitay same anukuntunna....i need exact answer. [/quote] i dont think so ..
150bryant Posted April 26, 2012 Report Posted April 26, 2012 [quote name='Help veerudu' timestamp='1335452699' post='1301690777'] avari dagara aina ee query ki answer untay plz post cheyandi!! [/quote] joins are horizontal join of tables on matched columns.. subqueries are used to return or retrieve a particular record or row based on conditional statments.
ganesh Posted April 26, 2012 Report Posted April 26, 2012 usually primary keys meeda create chestaru.....anni columns meeda cheyyochu..kani emi labham?
150bryant Posted April 26, 2012 Report Posted April 26, 2012 [quote name='google2011' timestamp='1335452728' post='1301690781'] ee link naku cheppava plz ??? [/quote] http://www.dbforums.com/db2/1647736-how-much-performance-hit-if-i-create-index-all-columns.html
google2011 Posted April 26, 2012 Author Report Posted April 26, 2012 [quote name='informatica86' timestamp='1335452748' post='1301690786'] 1)it will eat away space in the DB 2)updates will be slow on that table, when ever the recor is updated, it have to update index data portion also resulting in slow performance [/quote] [quote name='mtkr' timestamp='1335452752' post='1301690787'] update appudu slow untadi.... updating a column which has index on it is slower than updating a column which doesn't hav index on it... [/quote] oh yeah.. ee point miss ayyanu .. update slow ga untundi kada ... inka mimalni adigina questions emaina unte ekkada share cheyachu kada ... andarki use ayitadi ..
google2011 Posted April 26, 2012 Author Report Posted April 26, 2012 [quote name='ganesh' timestamp='1335452860' post='1301690801'] usually primary keys meeda create chestaru.....anni columns meeda cheyyochu..kani emi labham? [/quote] ala ani em undadu ankunta ganesh .. [quote name='jamajacha' timestamp='1335452921' post='1301690807'] [url="http://www.dbforums.com/db2/1647736-how-much-performance-hit-if-i-create-index-all-columns.html"]http://www.dbforums....ll-columns.html[/url] [/quote] thank you ... mimalni emaina questions adigi unte ekkada share cheyara plz....
ganesh Posted April 26, 2012 Report Posted April 26, 2012 [quote name='mtkr' timestamp='1335452752' post='1301690787'] update appudu slow untadi.... updating a column which has index on it is slower than updating a column which doesn't hav index on it... [/quote]anduke gaa konni process la loo index drop sesi data load ayyintaruvata malli index create settaru
Help veerudu Posted April 26, 2012 Report Posted April 26, 2012 [quote name='jamajacha' timestamp='1335452842' post='1301690798'] joins are horizontal join of tables on matched columns.. subqueries are used to return or retrieve a particular record or row based on conditional statments. [/quote] k thanks bhayya, actual ga interviewer same ques adigindu apudu nenu no same kadu ani chepina....naa answer ki vadu diff ga chusadu. so, appati nunchi nenu same emoo ani anukuntuna.
mtkr Posted April 26, 2012 Report Posted April 26, 2012 [quote name='ganesh' timestamp='1335452860' post='1301690801'] usually primary keys meeda create chestaru.....anni columns meeda cheyyochu..kani emi labham? [/quote] PK meedha automatic ga create aipothaddiiiii.... anni col meeda Y ante searching fasterr..
150bryant Posted April 26, 2012 Report Posted April 26, 2012 [quote name='Help veerudu' timestamp='1335453070' post='1301690824'] k thanks bhayya, actual ga interviewer same ques adigindu apudu nenu no same kadu ani chepina....naa answer ki vadu diff ga chusadu. so, appati nunchi nenu same emoo ani anukuntuna. [/quote] a sub query can written to perform the operations of a JOIN... like neeku result join lantidhi kaaavaali antey...subquery ni ala raayochu.. but in general terms..maatram...join is different from a subquery
google2011 Posted April 26, 2012 Author Report Posted April 26, 2012 [quote name='mtkr' timestamp='1335453136' post='1301690828'] PK meedha automatic ga create aipothaddiiiii.... anni col meeda Y ante searching fasterr.. [/quote] PK meda automatic ga create ayitada ??? ela ??
150bryant Posted April 26, 2012 Report Posted April 26, 2012 [quote name='google2011' timestamp='1335453038' post='1301690819'] ala ani em undadu ankunta ganesh .. thank you ... mimalni emaina questions adigi unte ekkada share cheyara plz.... [/quote] nenu mech engg ni.. software ki vachi 2 months aithundi inka training loney..una.. oka interview kuda attend avaledhu ...oka job kuda cheyaledhu.. im in learning process...nenem cheppagalanu job chesey mee lanti vallaki
150bryant Posted April 26, 2012 Report Posted April 26, 2012 [quote name='mtkr' timestamp='1335453136' post='1301690828'] PK meedha automatic ga create aipothaddiiiii.... anni col meeda Y ante searching fasterr.. [/quote] PK constraint manama istheyney kadha ayedhi.. automatic identifiers emaina untaaya?
ganesh Posted April 26, 2012 Report Posted April 26, 2012 [quote name='jamajacha' timestamp='1335453250' post='1301690847'] nenu mech engg ni.. software ki vachi 2 months aithundi inka training loney..una.. oka interview kuda attend avaledhu ...oka job kuda cheyaledhu.. im in learning process...nenem cheppagalanu job chesey mee lanti vallaki [/quote]hmmmm...software lo ala emi undadu...avasaram vacchinappudu nerchukovatam....cheppedi evarannadi kadu
google2011 Posted April 26, 2012 Author Report Posted April 26, 2012 [quote name='jamajacha' timestamp='1335453250' post='1301690847'] nenu mech engg ni.. software ki vachi 2 months aithundi inka training loney..una.. oka interview kuda attend avaledhu ...oka job kuda cheyaledhu.. im in learning process...nenem cheppagalanu job chesey mee lanti vallaki [/quote] nen kuda mech ee jamajacha .. kakapote 2 yrs nundi working le .. ayina enni dbts endulo training thiskuntunav ???
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
.thumb.gif.343fe49c7e1c507ae0056326bd8cf77e.gif)
Recommended Posts