How do you do the EXPLAIN of a dynamic SQL statement?

Answers were Sorted based on User's Feedback



How do you do the EXPLAIN of a dynamic SQL statement?..

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

How do you do the EXPLAIN of a dynamic SQL statement?..

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

Post New Answer

More DB2 Interview Questions

How to resolve deadlock issue

5 Answers   IBM,


What parameters are used to control the free space in DB2?

0 Answers  


Explain packages.

0 Answers  


What is db2 catalog database?

0 Answers  


Define declaration generator (dclgen).

0 Answers  


What is the physical storage length of date data type?

0 Answers  


How to create a table using embedded sql?

1 Answers  


what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,


Explain what a plan is?

3 Answers   CTS,


What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers  


How does DB2 use multiple table indexes?

1 Answers  


What are the functions in DB2?

3 Answers   Satyam,


Categories