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
- 8973 Views
- IBM, I also Faced
- E-Mail Answers
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
How and when does the db2 enforces the unique key?
What are host variables in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is role in db2?
What is the max length of sqlca?
Define db2 and its databases?
What is the physical storage length of date data type?
How to rename a table in DB2 ?
What is the purpose of using commit?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Define data page.
Is db2 free?
What is db2 and what is the use of db2 optimizer?
How to connect to db2 database from windows command line?
How to take backup of table in db2?
