Abstract: An improved system and method for storing, reusing and recompiling execution plans for SQL database queries. The system. The system validates the performance of a newly compiled plan prior to replacing a currently stored execution plan and compares the resource cost of the recompiled plan with the cost of the currently stored plan. In the event that the resource cost of the recompiled plan is not greater than the stored plan resource cost, the system replaces the currently stored execution plan with the recompiled plan.
Abstract: The invention provides a system and method for the reorganization of a database in a computing system. The method includes determining operations necessary to effect the reorganization of the database, estimating the completion time for the operations, and scheduling operations to be executed in the order of decreasing estimated completion time.