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
- 7159 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
What does runstats do in db2?
How do I delete a table in database?
What is temporal table in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Can there be more than one cursor open for any program?
How can we retrieve the total number of records in RPG & CLLE?
Can you tell me how can you find out the # of rows updated after an update statement?
Explain various types of locks in db2?
When do you specify the isolation level?
What is plan in cobol db2?
Is db2 a mainframe database?
What is ibm db2 connect?
What is the maximum size of varchar data type in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
