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
What is the latest version of ibm db2?
How to check last update on table in db2?
Define declaration generator (dclgen).
i want to maintain uniqueness on pdf without make lf??????????
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is a storage group (stogroup)?
What is scrollable cursor in db2?
What is the maximum size of varchar data type in db2?
How connect db2 database to datastage?
Mention some fields that are a part of sqlca.
List out the buffer pools in db2
What is a bind card?
What is cloudant database?
What is innodb buffer pool?
How do I add a column in db2?