Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What will the DB2 optimizer do?

Answer Posted / srinivas yadav

OPTIMIZER: IT CHOOSES THE BEST ACCESS PATH.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dbrm? What it contains?

1211


Where do you specify them?

1359


What r the comman abends in db2, jcl and cobol???????

2307


What does sqlcabc has?

1093


My sql statement select avg(salary) from emp yields inaccurate results. Why?

1128


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1239


What is the role of schema in the db2 database?

1354


What is collection in db2 bind?

1057


Give the name of some fields form sqlca.

1138


Before you give the explain statement, what are the prerogatives?

1079


What are the various isolation levels possible?

1177


What is dbrm library?

1112


How connect db2 database to datastage?

1289


What is plan in cobol db2?

1196


How can we retrieve the total number of records in RPG & CLLE?

705