×

Optimizing a query using a non-covering join index

  • US 6,643,636 B1
  • Filed: 06/05/2001
  • Issued: 11/04/2003
  • Est. Priority Date: 06/05/2001
  • Status: Expired due to Term
First Claim
Patent Images

1. A method for optimizing a SQL query, in which the SQL query includes a WHERE clause and a FROM clause, where the method includesevaluating whether a non-covering join index partially but not completely covers the query, and if it does adding the join index to the FROM clause of the query without removing the partially covered base tables;

  • modifying the WHERE clause of the query by;

    (1) mapping a query condition to the join index for its partially covered base tables; and

    (2) adding a join back condition from the join index to a base table from which the join index was formed.

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