Finding and fixing changes to access plans after rebinding packages
You can locate access plan changes that occurred after you rebound packages into another collection or rebound a new version of packages in a single collection.
Comparing access plans for two sets of identical packages that are in two different collections
You can find out whether rebinding packages after making changes to your system would change access plans and whether those changes would slow the execution of your SQL statements.
Comparing access plans for two different versions of the same packages in one collection
You can find out whether rebinding a set of packages made changes to access plans and whether those changes slow the execution of SQL statements.
Related tasks
:
Finding and fixing changes to access plans after adding, removing, or modifying SQL statements in an application
Finding and fixing changes to access plans after release migration or applying maintenance fixes
Finding and fixing changes to access plans after changes to database structure or authorizations
Finding and fixing changes to access plans after deploying an application from a test system to a production system
Feedback