Patent Number: 7,133,861

Title: Query access plan rebuilds

Abstract: A method, apparatus and system that in an embodiment detect that a trigger exists, where the trigger indicates a potential need to rebuild a saved query access plan, and determine whether a previous job associated with the trigger created a new access plan that was identical to the saved access plan. If a previous job associated with the trigger has already created the new access plan and found that it was identical to the saved access plan, then the query is performed with the saved access plan, since there is no advantage to be gained by creating the new access plan again. In this way, multiple jobs are kept from repeatedly re-creating an access plan that is identical to one that already exists.

Inventors: Day; Paul Reuben (Rochester, MN), Muras; Brian Robert (Rochester, MN), Ryg; Anne Marie (Mantorville, MN)

Assignee: International Business Machines Corporation

International Classification: G06F 7/00 (20060101); G06F 17/00 (20060101); G06F 17/30 (20060101)

Expiration Date: 2019-11-07 0:00:00