Interested to Buy Any Domain ? << Click Here >> for more details...
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 are bind parameters in db2?
How would you find out the total number of rows in a db2 table?
What is the syntax for FETCH in DB2 ?
What is buffer pool and list some of them?
Which is faster delete or truncate?
Mention the location where the output received from explain statement is stored.
How to view db2 table structure?
What is precompiler in db2?
What is declare cursor?
What are union and union all?
Explain in brief how does db2 determine what lock-size to use?
Define data page.
What is clone table?
What is commit in db2?
What is the use of with ur in db2?
