Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6085 Views
- I also Faced
- E-Mail Answers
Answer Posted / mehdee
- When we issue an EXPLAIN as of the BIND like EXPLAIN
(YES), then results to analyze the path will go into 3 DB2
tables: PLAN_TABLE, DSN_STATEMENT_TABLE &
DSN_FUNCTION_TABLE. And you can do:
- select * from fhtdev.plan_table; And columns are
defined in DB2 Developers Guide EXPLAIN.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is query_cache_limit?
What is package in db2 mainframe?
define clustering index.
List out the buffer pools in db2
What are the benefits of using the db2 database?
Are view updateable?
What is collection in db2 bind?
What is cobol db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is a page in db2?
What does db2 blu stand for?
What is a db2 schema?
What is the difference between oracle and db2?
What is dclgen in db2?
What is a plan and package in db2?
