Interested to Buy Any Domain ? << Click Here >> for more details...
What will the DB2 optimizer do?
- 2 Answers
- 6338 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 |
How many types of page locks can be held in db2?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is the purpose of the QUIESE Utility?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
what is load and unload in db2
Why do we use cursor?
What is runstats and reorg in db2?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
How do I import a csv file into db2?
WHAT IS MEANT BY COMMIT COMMAND?
What is the physical storage length of date data type?
When reorg is used?
COBOL 
