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
- 8982 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
Is the primary key a clustered index?
What is the maximum No of rows per page?
What is the picture clause of null indicator variable?
What is dbrm library?
How to find the number of rows in db2 tables?
What is dclgen (declaration generator)?
What is temporal table in db2?
What is an instance database?
How do I delete a column in db2?
What are catalog tables in db2?
How do I add a column in db2?
What kind of database is db2?
How to connect to db2 database from windows command line?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
