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
- 7857 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is db2 bind process?
Define check constraint.
What is scrollable cursor in db2?
How to connect to db2 database from windows command line?
Which component is responsible for db2 startup and shutdown?
How to resolve deadlock issue
What is a dbrm in db2?
What is an instance database?
What is meant by union and union all?
Name the various locking levels available?
How can you do the explain of a dynamic sql statement?
Are view updateable?
What is ibm db2 used for?
What is the use of value function?
Why do we need reorg in db2?
