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
Which command is used to connect to a database in DB2 ? Give the Syntax.
What r the comman abends in db2, jcl and cobol???????
Why cursor is used in db2?
How to create db2 table in mainframe?
What is the difference between drop table and delete table?
What is explain in db2?
How do I start db2 in windows?
Explain the benefits you can get from mainframe connect?
What db2 400?
What is null in db2?
What is meant by dclgen?
Which are the db2 tools to protect integrity of the database?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What does db2 plan contain?
What is multi row fetch in db2?
