What will the DB2 optimizer do?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srinivas yadav
OPTIMIZER: IT CHOOSES THE BEST ACCESS PATH.
Is This Answer Correct ? | 2 Yes | 0 No |
What are the functions in DB2?
difference between group clause and order clause
What are leaf pages?
wt is view ? wht r the restrictions for view ?
Mention and explain the contention situations caused by locks?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
How to create a table using embedded sql?
What is a db2 schema?
What type of database is db2?
How can you find out the # of rows updated after an update statement?
What is db2 isolation?
How does the processing of a correlated subquery differ from a non correlated subquery?