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 / s

The optimizer will determine all the different access paths
for the query and does a cost-based analysis and chooses
the the least expensive path.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about dbrm.

1038


What is netezza database?

1019


What is the purpose of rollback and commit?

1187


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2210


How do I connect my db2 database to ibm?

1043


What is buffer pool and list some of them?

1023


What is database reorganization?

1121


Which is faster delete or truncate?

1123


what is utility for parm lib

2368


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

1186


What is the maximum size of varchar data type in db2?

1130


What are catalog tables in db2?

1044


What is the maximum length of sqlca?

1519


How do I copy a table in db2?

996


What is the clustering index in the db2 database?

1000