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 deadlocks be resolved?
What is nvl in db2?
What is the role of data manager in the db2 database?
How to test SQL -911 error while developing COB-DB2 program
How to find the number of rows in db2 tables?
How can we read records for specific member in CL? AND rpg?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do we specify index to include or not during bind process.
What is the difference between using bind () and rebind () methods of naming class?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is ibm db2 used for?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is plan in cobol db2?
what is diffrence b/w file-aid tool and file-aid utility???
