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
- 7158 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
List out the three types of page locks that can be held.
What does db2 stand for?
What is the maximum number of columns in a db2 table?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What are the full forms of spufi and dclgen and why are they used?
What are db2 objects?
Why do we need reorg in db2?
What is a db2 table?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is the role of union all and union
What is null in db2?
What does db2 mean?
Explain packages.
What do you mean by cursor?
Are views updateable?
