what is the steps followed in EXPLAIN Process or EXPLAIN
command. (Explain is for identifying the optimized access
path but how or what is the steps for doing the EXPLAIN)
- 4 Answers
- 7881 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sdexcellent@yahoo.co.in
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 ).
plan table should be created under your authid.if its there
then only EXPLAIN can be used in SPUFI.
Output of EXPLAIN can be stored in userid.plantable
in spufi u ve to write the query with ?
select billtn,lpic from xxxx where lpic > ?
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you find the maximum value in a column in db2?
What are the various data types available in db2?
What is the difference between nvl and coalesce?
What are the two types of logging in the db2 database? Explain them.
What is the maximum number of columns in a db2 table?
How can you find out the # of rows updated after an update statement?
What are the various isolation levels possible?
Why do we need reorg in db2?
What is explain in db2?
What is a bind card?
Why db2 is called db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
what is the responsibility of the construction superintendent
What is table space in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
