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
How do you stop a db2 database in linux?
What is the max length of sqlca?
What does db2 stand for?
What is phantom read in db2?
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?
List out the data types available.
List down the data types in the db2 database.
Is db2 a programming language?
i want to maintain uniqueness on pdf without make lf??????????
How many databases are there?
What is the difference between bind and rebind in db2?
What is clone table?
What is the difference between plan and package in db2?
What is the information associated with sysibm.syslinks table?
Explain about rct.