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)
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 the maximum size of varchar data type in db2?
Name the lockable units in DB2?
How to check sequence on a table in db2?
How do you select a row using indexes in db2?
How many types of page locks can be held in db2?
What is buffer pool?
What is a bind card?
What is the use of dclgen in db2?
How do you find the maximum value in a column in db2?
Define db2 and its databases?
Which isolation level provides highest data integrity?
Can we delete records from view?
What is load utility in db2?
How do I copy a table in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference