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
- 8709 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
Where do you specify them?
What is the use of with ur in db2?
Mention data types used in db2 ?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How does a cursor work?
What is difference between alias and synonym in db2?
What is with ur in db2?
How do I import a csv file into db2?
What is dbrm? When it will be created?
What is the syntax for creating a table in the db2 database?
Comment whether the cursor is closed during commit or not.
What is db2 stogroup?
What is coalesce in db2?
Mention some fields that are a part of sqlca.
How do I add a column to an existing table in db2?
