How do you do the EXPLAIN of a dynamic SQL statement?
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 dbrm?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is a Foreign Key?
What os does db2 run on?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
what is utility for parm lib
How do I delete a table in db2?
Name the lockable units in DB2?
Explain the contention situations caused by locks?
Which component is responsible for db2 startup and shutdown?
What is bind plan?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What are db2 objects?
What is a db2 collection?
What is precompiler in db2?