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)
Answer Posted / bob
Small Correction: With explain(Yes) option, Access path or optimizer's strategy/information will be stored in package_owner.plan_table
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the role of the data page in the db2 database?
Differentiate between cs and rr isolation levels? Where do you specify them?
What are db2 objects?
Name the lockable units in DB2?
How to check last update on table in db2?
What is a db2 collection?
What is bind plan?
What are the 2 sqlcodes that are returned?
What is dbrm? What it contains? When it will be created?
What is the difference between db2 and oracle?
What is the purpose of using commit?
Why do we use cursor?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the clustering index in the db2 database?
How to restart a DB2 program?