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 many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
wht is d/f between union and joins ?
What keyword does an SQL SELECT statement use for a string search?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
Define check constraint.
What is db2 bind process?
What is a db2 collection?
What do the initials DDL and DML stand for and what is their meaning?
What is db2 command?
Is it possible to precompile if db2 goes down?
How do you retrieve the first 5 characters of firstname column of db2 table emp?