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
- 8976 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
Which component is responsible for db2 startup and shutdown?
Is db2 relational database?
Explain about cursor stability?
What are the contents of a dclmgen?
What is cursor with hold option in db2?
what is db2 restart?
What language is db2 written in?
What is the difference between db2 and oracle?
What is performance tuning db2?
Explain the contention situations caused by locks?
What is concurrency?
What does runstats do in db2?
Which component is responsible for processing sql statements and selecting access paths?
How to find primary key of a table in db2?
How to get the ddl of a table in db2?
