Answer Posted / sadiq afroze
EXPLAIN is used to display the access path as determined by
the optimizer for a SQL statement. It can be used in SPUFI
(for single SQL statement) or in BIND step (for embedded
SQL). The results of EXPLAIN is stored in U.PLAN_TABLE
where U is the authorization id of the user
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How do I delete a column in db2?
How to find schema of a table in db2?
List out the data types available.
What is the max length of sqlca?
What is the latest version of ibm db2?
What is difference between isnull and coalesce?
What is rct?
What is an instance in db2?
How to rename a table in DB2 ?
what is the responsibility of the construction superintendent
What is iseries database?
Is db2 free?
What is the function of logging in the db2 database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is drop table?