×

System and method for addressing inefficient query processing

  • US 7,376,638 B2
  • Filed: 12/24/2003
  • Issued: 05/20/2008
  • Est. Priority Date: 12/24/2003
  • Status: Active Grant
First Claim
Patent Images

1. A method of analyzing query performance based on predicate usage, comprising:

  • collecting performance statistics for database queries comprising database statements entered by end-users having different predicate combinations;

    organizing the performance statistics based on the different predicate combinations of the database queries;

    analyzing performance of a subset of the database queries having different predicate combinations that include common predicates;

    generating analysis results; and

    identifying a problem from a list consisting of;

    missing statistics on an added column, missing index on new column, missing multi-column index on a fact table, and predicate contains a non-indexable operator.

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