Interested to Buy Any Domain ? << Click Here >> for more details...
What will the DB2 optimizer do?
- 2 Answers
- 6225 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 |
What are the levels of isolation available with DB2V4
What is a SELECT statement?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the purpose of the QUIESE Utility?
How to test SQL -911 error while developing COB-DB2 program
What is bufferpool in db2?
What is Declaration Generator(DCLGEN)?
What does an outer join do?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What is the SQL query to select, delete and get count of duplicate rows in DB2?
Name the different types of Table spaces.
COBOL 
