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
Can we insert update delete in view?
What is the difference between dbm cfg and db cfg file in db2 ?
What is with ur in db2?
What is release/acquire in bind?
How can you quickly find out the # of rows updated after an update statement?
How to execute stored procedures?
What is db2 plan table?
What is check constraint in db2?
Which is faster delete or truncate?
What are concurrency issues?
How and when does the db2 enforces the unique key?
What r the comman abends in db2, jcl and cobol???????
What is rebind in db2?
What is the purpose of using commit?
What is a page in db2?
