Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is the use of db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is a buffer in memory?
What is buffer pool in the db2 database?
Is it possible using max on a char column?
What is the use of value function?
How is the value function used?
What is runstats utility in db2?
Which component is responsible for db2 startup and shutdown?
Which is faster delete or truncate?
What is difference between alias and synonym in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
Is db2 a mainframe database?
Outputs of explain are with matchcols = 0. What does this signify?
What are the full forms of spufi and dclgen and why are they used?
