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 |
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is netezza database?
What will the COMMIT accomplish?
What is lock contention?
What is a synonym? How is it used?
wht are the restrictions for union ?
What is dbrm? What it contains?
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)
How does DB2 determine what lock-size to use?
What is a DB2 plan?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is read-only cursor?