Interested to Buy Any Domain ? << Click Here >> for more details...
what is the steps followed in EXPLAIN Process or EXPLAIN
command. (Explain is for identifying the optimized access
path but how or what is the steps for doing the EXPLAIN)
- 4 Answers
- 8940 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / krishna
In bind parameter if you give like
EXPLAIN(YES)
This will store the acess path in SYSIBM.SYSPLAN table,
it will not do any optimization.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is commit in db2?
Can we update view in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
Mention the different locking levels that are available in db2.
What is null indicator in db2?
Define buffer pool.
What is the maximum length of sqlca?
What is db2 purescale?
What is node in db2?
What is a db2 package?
Explain correlated sub-queries.
How would you find out the total number of rows in a db2 table?
How to execute stored procedure in db2 command editor?
What is ibm db2 used for?
What is db2 connect?
