×

SQL EXECUTION PLAN VERIFICATION

  • US 20140236921A1
  • Filed: 04/11/2014
  • Published: 08/21/2014
  • Est. Priority Date: 10/17/2007
  • Status: Active Grant
First Claim
Patent Images

1. A system comprising:

  • a query optimizer configured to generate query plans for executing database commands;

    a repository configured to store verification data that identifies a first set of the query plans as having been designated as acceptable for executing database commands, and a second set of the query plans as awaiting verification;

    wherein the query optimizer is further configured to select particular query plans, of the query plans generated by the query optimizer, to execute particular database commands, based at least in part on whether the verification data indicates that the particular query plans are within the first set;

    a database server configured to execute particular query plans selected by the query optimizer;

    a verification component configured to;

    perform comparisons of first performance statistics collected during execution of first query plans in the first set of the query plans to second performance statistics collected during execution of second query plans in the second set of the query plans, and update the verification data to move one or more of the second query plans from the second set to the first set based on the comparisons.

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