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
- 18559 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
What are bind parameters in db2?
what is the sqlcode -501
Mention the location where the output received from explain statement is stored.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What's The Error Code For Unique Index Voilation?
What is cascading rollback?
What is the reason behind not using select * in embedded sql programs?
What is access path in db2?
Which command is used to remove all rows from a table?
How is the value function used?
How to access db2 tables in mainframe?
What is concurrency?
How do I add a column to a table in db2?
What is buffer pool?
How can record locking be achieved in those DB2 versions which do not support it?
