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
- 8712 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
Explain in brief how does db2 determine what lock-size to use?
Can we insert update delete in view?
Can you use max on a char column?
Who uses db2?
On which levels locks can be applied?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Is db2 a mainframe database?
How do I delete a column in db2?
What is a Foreign Key?
When do you specify the isolation level?
What is dbrm? What it contains? When it will be created?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How do we specify index to include or not during bind process.
What is database reorganization?
What does reorg do in db2?
