Patent ID: 7870123
Filing Date: 2011-01-11
Classification: G06F

Abstract:
1. A method of determining the performance of an optimizer program arranged to generate a plan, the method comprising the steps of: executing, by a processing node of a database system, an optimizer utilizing at least one test case to derive a pre-variation plan; executing, by the processing node, the derived pre-variation plan to generate a first output; varying, by the processing node, a strategy of the optimizer by changing at least one of a costing algorithm strategy utilized by the optimizer and a cardinality estimate mechanism of the optimizer; executing, by the processing node, the varied strategy of the optimizer utilizing the at least one test case to derive a post-variation plan; executing, by the processing node, the derived post-variation plan to generate a second output; and grouping, by the processing node, the generated first and second outputs according to at least one element of the derived pre-variation and post-variation plans, wherein the performance of the optimizer is determined based on the grouping.