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
- 16823 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
Explain about rct.
What is check constraint in db2?
What is database manager in db2?
Is db2 a programming language?
Can one database have multiple instances?
What is universal database?
What is performance tuning db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is db2 stogroup?
What is deadlock in db2?
Discuss about db2 bind?
Highlight all the advantages that are attached to a package.
How to rename a table in DB2 ?
How will you return the number of records in table?
How do I delete a column in db2?
