Interested to Buy Any Domain ? << Click Here >> for more details...
What is an EXPLAIN in DB2.
How and what is the steps followed in EXPLAIN command. Can
all the queries be used in EXPLAIN command to check the
performance.
- 3 Answers
- 18731 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / s.v.venkata sivaprasad
explain is the db2 tool which used to improve db2
performance and provides best access path to package
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between cs and rr isolation levels? Where do you specify them?
Define db2 and its databases?
When the like statement is used?
What are the two types of logging in the db2 database? Explain them.
What is the difference between plan and package in db2?
How would you find out the total number of rows in a db2 table?
Where do you specify them?
How do I add a column in db2?
What is a buffer in memory?
What is the difference between using bind () and rebind () methods of naming class?
What is buffer pool?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What are union and union all?
How can deadlocks be resolved?
What is isolation level in db2?
