What do you need to do before you do EXPLAIN ?
Answer / naveen87ginjupalli
The Plan_table is created under the AUTHID.
| Is This Answer Correct ? | 5 Yes | 0 No |
What is an instance database?
Can we delete records from view?
What is a db2 table?
can any body explain about plan and pakage in detail....
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
What is deadlock in db2?
What does db2 plan contain?
When reorg is used?
what is the input to PLAN? what is the input to DBRM?
Why select is not preferred in embedded sql programs?
Where are plans stored?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th