Answer Posted / s
EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is multi row fetch in db2?
How to check table size in db2 sap?
What is sqlca’s maximum length?
What is universal database?
Explain the contention situations caused by locks?
What is isolation level in db2?
What is difference between alias and synonym in db2?
What is query_cache_limit?
What is an instance database?
What is dbrm? What it contains?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the use of commit in db2?
What is copy pending status in db2?
How to fetch the last row from the table in SQL (db2)?
What type of database is db2?