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
- 8897 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
Define sqlca.
Define buffer pool.
What is db2 stogroup?
Before you give the explain statement, what are the prerogatives?
What is null in db2?
What is null value in db2?
Define db2 and its databases?
What does db2 stand for?
What is the information associated with sysibm.syslinks table?
What is a trigger in the db2 database?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What kind of database is db2?
How to take backup of table in db2?
Explain db2.
What is the use of value function?
