what is rebinding ?
- 1 Answers
- 5475 Views
- IBM, I also Faced
- E-Mail Answers
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 |
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What are some characteristics of columns that benefit from indexes?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What will happen, while trying to close the closed cursor.
What is a DB2 access path?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is a precompiler?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What are db2 tables?
Are views updateable?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
COBOL 
