Interested to Buy Any Domain ? << Click Here >> for more details...
What will the DB2 optimizer do?
- 2 Answers
- 6200 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 can you display the current date & current time ?
What is blu acceleration in db2?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What is db2 bind process?
What is dynamic SQL?
what is the process of precompiler?
what is a plan and how do you refer the plan in the program?
On which levels locks can be applied?
Comment whether the cursor is closed during commit or not.
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is the difference between Where and Having Clause
where will u check for sqlcode ?
COBOL 
