Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9170 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 release/acquire in bind?
List some fields from sqlca?
What is drop table?
What is runstats db2?
what is a corelated subquerry?
How do I change the column size in db2?
What is a db2 cursor?
What is the default page size of buffer pools?
What are the contents of dclgen?
What is host variable in db2 cobol?
How many databases are there?
Give the name of some fields form sqlca.
What is the difference between plan and package in db2?
What are host variables in db2?
What is dclgen (declaration generator)?
