Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6194 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 language is db2 written in?
What is db2 optimizer?
Explain the function done by data manager?
How will you return the number of records in table?
What is temporal table in db2?
Can there be more than one cursor open for any program?
How does coalesce work?
What is database reorganization?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is the syntax for seeing the columns and data types of a table in the db2 database?
what is the role of the cursor in db2?
What parameters are used to control the free space in DB2?
What is the result of open cursor statement?
What is sqlca’s maximum length?
