What is EXPLAIN?
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 |
What is the result of open cursor statement?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What will the DB2 optimizer do?
Name the lockable units in DB2?
Name the different types of Table spaces.
Who uses db2?
What is the role of data manager in the db2 database?
What is the SQL Communications Area and what are some of its key fields?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is filter factor?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?