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
- 8998 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
When do you specify the isolation level?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How is the value function used?
What is bind plan?
What is buffer pool in the db2 database?
Mention the various locks that are available in db2.
what is the sqlcode -501
Explain what are the various isolation levels possible?
What is the difference between cursor and select statement?
Why do chiropractors use drop table?
What is explain in db2?
How do I delete a column in db2?
what is the role of the cursor in db2?
What is coalesce in db2?
List some fields from sqlca?
