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 are db2 tables?

1094


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2903


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

1177


Explain in brief how does db2 determine what lock-size to use?

1020


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9151


What is lock escalation in db2?

1003


what is the sqlcode -501

13076


On which levels locks can be applied?

1109


Define predicate?

1103


How does cobol compile db2 program?

1034


What is cobol db2?

980


What does db2 mean?

991


What is dbrm? When it will be created?

1009


What is declare cursor?

1101


What is buffer pool and list some of them?

1005