Interested to Buy Any Domain ? << Click Here >> for more details...
How do you do the EXPLAIN of a dynamic SQL statement?
- 2 Answers
- 6182 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
Can there be more than one cursor open for any program?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Define predicate?
What is commit in db2?
What is deadlock in db2?
What is db2 purescale?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Explain db2.
What are the prerogatives?
How to compare data between two tables in db2?
What is the physical storage length of date data type?
What is the syntax for creating a table in the db2 database?
How do you pull up a query which was previously saved in qmf?
What kind of database is db2?
What happens in bind step in a db2 program?
