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
Explain about cursor stability?
What is check constraint in db2?
What is the maximum size of varchar data type in db2?
What is the difference between drop table and delete table?
What is a page in db2?
What is the physical storage length of time data type?
What is meant by union and union all?
What is release/acquire in bind?
What is a Foreign Key?
What are the full forms of spufi and dclgen and why are they used?
What is an instance database?
What is the use of value function?
Give a brief description of db2 isolation levels?
How to retrieve rows from a db2 table in embedded sql?
How and when does the db2 enforces the unique key?