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
- 8925 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
Why cursor is used in db2?
What are the various data types available in db2?
How is deadlock resolved?
What is dbrm in db2 database?
How to find schema of a table in db2?
What are the contents of dclgen?
How does db2 sample database connect?
How can you find out the # of rows updated after an update statement?
What is the clustering index in the db2 database?
What is temporal table in db2?
How to get the ddl of a table in db2?
Why db2 is called db2?
What are types of indexes?
What are db2 objects?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
