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 are union and union all?
Which component is used to execute the sql statements?
What is the meaning concurrency in the db2 database?
What is db2 connect?
Why cursor is used in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How do I delete a table in database?
What is db2 command?
What is reorg?
What is clone table?
What is drop table?
What is buffer pool and list some of them?
How can you count the number of rows from a table tab?
What is the use of commit in db2?
Mention the various locks that are available in db2.
