×

System and method for performing a query in a computer system to retrieve data from a database

  • US 20050065921A1
  • Filed: 09/22/2004
  • Published: 03/24/2005
  • Est. Priority Date: 09/22/2003
  • Status: Active Grant
First Claim
Patent Images

1. A method of performing a query in a computer system to retrieve data from a database stored on the computer system which comprises a Data-Base Management System (DBMS) with an optimizer, the method comprising:

  • generating a Query Execution Plan (QEP) for the query;

    assessing said QEP by considering statistical values about previous executions of said query according to said QEP;

    determining whether to choose said QEP or to generate a new QEP;

    executing said query according to the generated QEP; and

    collecting statistical values during execution for optimizing an execution of future queries.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×