×

Deferred maintenance of sparse join indexes

  • US 8,032,503 B2
  • Filed: 08/05/2008
  • Issued: 10/04/2011
  • Est. Priority Date: 08/05/2008
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • defining a snapshot join index from a join index table using a sparse condition in a join index definition;

    comparing a new sparse condition of the snapshot join index with an old sparse condition, wherein the comparing identifies an incremental delta condition between the new sparse condition and the old sparse condition;

    identifying rows in a base table as a function of the comparing; and

    updating rows in the join index table as a function of the identified rows in the base table.

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