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 you use max on a char column?
What is release/acquire in bind?
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
What does a deadlock mean in DB2?
i want to maintain uniqueness on pdf without make lf??????????
What is a bind card?
What are types of indexes?
Mention the definition of cobol in varchar field.
Explain correlated sub-queries.
What is the max length of sqlca?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is an instance database?
How can deadlocks be resolved?
What is a collection in db2?
What is db2 stogroup?