Explain the EXPLAIN statement?
Answer / 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 |
What is blu acceleration in db2?
Define buffer pool.
What is meant by a unit of recovery?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a LIKE table and how is it created?
How to resolve -917 sql code in DB2?
What is the clustering index in the db2 database?
What will the COMMIT accomplish?
What are the different types of base tables?
What is a lock?
what is copy pending and check pending ?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.