Answer Posted / sravani
when sql statements are not changed but a new index is added or runstats is run,then it is advisable to do a rebind for the
best possible access path. rebind plan is cheaper than bind with action(replace)
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the difference between nvl and coalesce?
How to restart a DB2 program?
What is a dbrm in db2?
How do you find the maximum value in a column in db2?
How many databases can be created inside an instance in db2 ?
Explain about cursor stability?
What is the advantage in De-normalizing tables in DB2?
Name the lockable units in DB2?
What is the max length of sqlca?
How can you do the explain of a dynamic sql statement?
What is db2 and what is the use of db2 optimizer?
How to fetch the last row from the table in SQL (db2)?
How do I delete a table in db2?
What is db2 stogroup?
