Patent ID: 7739269
Filing Date: 2010-06-15
Classification: G06F

Abstract:
1. A system embodied on a computer-readable storage medium that facilitates incremental repair of existing query plans, the system comprising: an optimizer component that generates a query plan and designates the generated query plan as an existing query plan; a designate component that selectively determines whether to repair or recompile the existing query plan, wherein the determination to repair is based on meeting or exceeding a first threshold level and the determination to recompile is based on meeting or exceeding a second threshold level, wherein further the first threshold level and the second threshold level comprise an update activity in a database; and an incremental repair component that receives the existing query plan and selectively repairs the existing query plan utilizing an incremental repair technique, the incremental repair component including an evaluator component for evaluating the leaf-nodes of the existing query plan against any changes to a database.