what is rebinding ?
Answer / 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 |
How can you get the number of rows impacted by the last executed query?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is EXPLAIN?
What is plan in cobol db2?
Name the lockable units in DB2?
What is the difference between nvl and coalesce?
What is UNION,UNION ALL?
can any one expalin check point with an example?
What is dbrm?
What is a clustering index?
What should be specified along with a cursor in order to continue updating process after commit?
Is ibm db2 open source?