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 the difference between drop table and delete table?
Explain in detail about buffer manager and its functionalities?
When reorg is used?
What is nvl in db2?
B37 abend during spufi?
What is plan in cobol db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What are the 2 sqlcodes that are returned?
What is the max length of sqlca?
What is collection in db2 bind?
What is access path in db2?
Is ibm db2 open source?
List down the data types in the db2 database.
What are foreign keys in db2?
What is load utility in db2?
