Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6052 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
Mention the definition of cobol in varchar field.
What r the comman abends in db2, jcl and cobol???????
What is the syntax for seeing the columns and data types of a table in the db2 database?
How to execute stored procedures?
How and when does the db2 enforces the unique key?
What is page size in db2?
What are the contents of dclgen?
What is the difference between db2 and oracle?
Describe major components of db2?
What is check constraint. Explain with example.
What is isolation level in db2?
What is difference between isnull and coalesce?
What is the advantage in De-normalizing tables in DB2?
What is query_cache_limit?
Why db2 is called db2?
