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
- 9181 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
How does coalesce work?
What is the role of schema in the db2 database?
What is ibm db2 client?
What is host variable?
What parameters are used to control the free space in DB2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
List down the data types in the db2 database.
Which components manage deadlocks in db2?
What is the difference between using bind () and rebind () methods of naming class?
How to view db2 table structure?
what is a corelated subquerry?
How to execute stored procedures?
Explain about rct in db2?
What is netezza database?
