Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6295 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
Give a brief description of db2 isolation levels?
What is consistency token in db2?
What is check constraint in db2?
Are views updateable?
What is the role of data manager in the db2 database?
Explain about mirror activator disk mirroring?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is db2? Explain.
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What os does db2 run on?
Can you use max on a char column?
How do I add a column to a table in db2?
Is the primary key a clustered index?
How do we specify index to include or not during bind process.
What is innodb buffer pool?
