Interested to Buy Any Domain ? << Click Here >> for more details...
What will the DB2 optimizer do?
- 2 Answers
- 6323 Views
- I also Faced
- E-Mail Answers
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 |
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
How to find the number of rows in a db2 table?
What is Reorg Recovery? when will you run it?
How can you do the explain of a dynamic sql statement?
What is db2 connect?
What is cursor?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
Can SQL statements/queries be included in a copybook?
What is the difference between bind and rebind in db2?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
COBOL 
