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

How do you stop a db2 database in linux?

745


What is the max length of sqlca?

961


What does db2 stand for?

763


What is phantom read in db2?

825


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1839


List out the data types available.

912


List down the data types in the db2 database.

812


Is db2 a programming language?

788


i want to maintain uniqueness on pdf without make lf??????????

1893


How many databases are there?

774


What is the difference between bind and rebind in db2?

1179


What is clone table?

786


What is the difference between plan and package in db2?

825


What is the information associated with sysibm.syslinks table?

879


Explain about rct.

858