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
- 7889 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
How to execute stored procedure in db2 command editor?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How do I import data from excel to db2?
What are concurrency issues?
What is drop table?
What is dbrm?
What is an instance database?
What are the contents of a dclmgen?
What are the benefits of using the db2 database?
How to check table size in db2 sap?
Give a brief description of db2 isolation levels?
What is a db2 package?
What are db2 objects?
How is the value function used?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
