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
- 9180 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bob
Small Correction: With explain(Yes) option, Access path or optimizer's strategy/information will be stored in package_owner.plan_table
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sachin borase
Optimized access path means:
When we are runnign any query database make the
path to db2 for fetching the required data called as
optimized acess path.for creating optimized access path
db2 uses db2 catlg.
expalain?
if put EXPLAIN(yes) then optimized path will sotred
whatever query you written in the program in the
table owner.plan_table
How to acess:
if you acess the owner.plan_table
it will have the below imp coloumns.
1.program name
2.latest timestamp
3.indexused
4.and more details
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / krishna
In bind parameter if you give like
EXPLAIN(YES)
This will store the acess path in SYSIBM.SYSPLAN table,
it will not do any optimization.
| Is This Answer Correct ? | 1 Yes | 1 No |
What is runstats db2?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is role in db2?
How does the processing of a correlated subquery differ from a non correlated subquery?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is a synonym? How is it used?
pls explain the precompilation process of cobol-db2 pgm
Can a array declared with an index be displayed(readable format) in spool?
how to resolve -811
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
max number of columns in a db2 table?
COBOL 
