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 dbrm.
What is netezza database?
What is the purpose of rollback and commit?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How do I connect my db2 database to ibm?
What is buffer pool and list some of them?
What is database reorganization?
Which is faster delete or truncate?
what is utility for parm lib
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the maximum size of varchar data type in db2?
What are catalog tables in db2?
What is the maximum length of sqlca?
How do I copy a table in db2?
What is the clustering index in the db2 database?