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
- 7126 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
What is difference between rollback and commit?
What are the contents of dclgen?
What is the difference between cursor and select statement?
What is ibm db2 client?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is nvl in db2?
What is cursor in dbms?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What are the bind parameters ibm db2?
How can you classify the locks in db2?
List down the data types in the db2 database.
What is database alias db2?
What is cursor with hold option in db2?
What is null in db2?
