Answer Posted / s
EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is sqlca’s maximum length?
What is database reorganization?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
define clustering index.
Before you give the explain statement, what are the prerogatives?
What is schema in db2?
what is a corelated subquerry?
What is the syntax for creating a table in the db2 database?
How do I import data from excel to db2?
What is the use of commit in db2?
How to test SQL -911 error while developing COB-DB2 program
What is the use of value function?
On which levels locks can be applied?
How is a typical db2 batch pgm executed?
How can you classify the locks in db2?