Interested to Buy Any Domain ? << Click Here >> for more details...
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 can we read records for specific member in CL? AND rpg?
How to create backup table in db2?
What is the purpose of rollback and commit?
What is db2 and what is the use of db2 optimizer?
What is a bind card?
What is the function of logging in the db2 database?
What is the difference between plan and package in db2?
How to resolve deadlock issue
Mention the location where the output received from explain statement is stored.
Mention the downsides of page level lock.
What do you mean by rollback?
What does a deadlock mean in DB2?
What is check constraint. Explain with example.
What is with ur in db2?
How to find the number of rows in db2 tables?
