How do you do the EXPLAIN of a dynamic SQL statement?
Answers were Sorted based on User's Feedback
Answer / swetha dasari
we could replace the unknown values with a "?"
eg:
select name
from database
where name = ?
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / 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 |
How to resolve deadlock issue
What parameters are used to control the free space in DB2?
Explain packages.
What is db2 catalog database?
Define declaration generator (dclgen).
What is the physical storage length of date data type?
How to create a table using embedded sql?
what is SMP/E? and what are the major steps of it? thanks...
Explain what a plan is?
What is the cobol picture clause of the db2 data types date, time, timestamp?
How does DB2 use multiple table indexes?
What are the functions in DB2?