×

TRANSFORMATION RULE PROFILING FOR A QUERY OPTIMIZER

  • US 20110314000A1
  • Filed: 06/18/2010
  • Published: 12/22/2011
  • Est. Priority Date: 06/18/2010
  • Status: Active Grant
First Claim
Patent Images

1. A method for transformation rule profiling for a query optimizer, comprising:

  • obtaining a database query configured to be optimized by the query optimizer of a database system;

    finding an optimized query plan for the database query using a host set of transformation rules;

    removing individual transformation rules from a query plan generation, wherein one transformation rule is removed and checked at a time;

    generating a test query plan after one transformation rule has been removed;

    determining whether the test query plan is different than the optimized query plan in the absence of the removed transformation rule; and

    creating an equivalent set of transformation rules that includes transformation rules where the test query plan generated from the equivalent set of transformation rules is equivalent to the optimized plan.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×