×

Method and mechanism for partition pruning

  • US 6,965,891 B1
  • Filed: 02/27/2001
  • Issued: 11/15/2005
  • Est. Priority Date: 02/27/2001
  • Status: Active Grant
First Claim
Patent Images

1. A method of executing a query, the query comprising a non-single table predicate that references a first database object and a second database object, the method comprising:

  • transforming said query into a transformed query that includes a new predicate, said new predicate corresponding to said non-single table predicate, said new predicate comprising a subquery that is not in said query;

    determining a result set for said subquery;

    evaluating said result set to identify a first set of partitions relevant to said query; and

    pruning a second set of partitions not relevant to said query.

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