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 |
What is the latest version of ibm db2?
What is DCLGEN?
How do you define a correlated name?
What does it mean if the null indicator has -1, 0, -2?
What is a composite index and how does it differ from a multiple index?
How to access db2 tables in mainframe?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What is a buffer pool?
What is SPUFI?
What is database alias db2?
What does db2 blu stand for?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.