What is EXPLAIN?
- 1 Answers
- 5574 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How can you count the number of rows from a table tab?
What language is db2 written in?
What will happen, while trying to close the closed cursor.
what are stage one indexable predicates?
What is query_cache_limit?
how to take the back up of the DB2 table.
What is isolation level in db2?
What is release/acquire in bind?
What are the various locks available?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
what is Runstats? Whem will u choose to runatats?
wht r the requirements for writing a cobol-db2 pgm ?
COBOL 
