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
- 7161 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 are union and union all?
What is lock escalation in db2?
List out the three types of page locks that can be held.
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is dclgen (declaration generator)?
What is deadlock in db2?
What is db2? Explain.
How can you do the explain of a dynamic sql statement?
Which components manage deadlocks in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is a storage group (stogroup)?
Explain the contents that are a part of dclgen.
What is ibm db2 client?
Define db2 and its databases?
What is the physical storage length of timestamp data type?
