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
What is explain plan in db2?
What is the reason behind not using select * in embedded sql programs?
How to check sequence on a table in db2?
What are the 2 sqlcodes that are returned?
How to rename a table in DB2 ?
What is the difference between cursor and select statement?
What is copy pending and check pending in db2?
What is view db2?
How do I delete a table in database?
Mention the downsides of page level lock.
What is db2 purescale?
What is the maximum size of a char data type in db2?
Define check constraint.
What are the full forms of spufi and dclgen and why are they used?
How do we specify index to include or not during bind process.
