Where are plans stored?
Answers were Sorted based on User's Feedback
Answer / s
The Bound plans are stored in the SKCT tablespace in
DSNDB01 directory.
Is This Answer Correct ? | 2 Yes | 1 No |
What is the use of db2?
My SQL is not performing well. Describe how will you fine tune it?
Which isolation level provides highest data integrity?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
what is static sql? what is dynamic sql? Give me details
How to fetch the last row from the table in SQL (db2)?
What is db2 bind?
What is the difference between dbm cfg and db cfg file in db2 ?
Which are the db2 tools to protect integrity of the database?
How to find primary key of a table in db2?
List down the data types in the db2 database.
What does runstats do in db2?