Rebinding existing packages
Rebind is the process of recreating a previously bound package. Rebinding becomes necessary in the following scenarios:
- When the database statistics are updated, we should rebind the existing packages so that fresh access plans are generated. These new access plans will be based on the latest statistics. It becomes significant if any new indexes are added to a table. In such cases, rebinding will result in access plans that can use this index. This is necessary for consistent performance.
- If any database object that has a dependency on a package is dropped, then the package becomes invalid. In such cases, we need to rebind the package. This rebinding is optional as all invalid packages are automatically validated and ...
Get IBM DB2 9.7 Advanced Application Developer Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
