×

Method and apparatus for using a hash-partitioned index to access a table that is not partitioned or partitioned independently of the hash partitioned index

  • US 20050251524A1
  • Filed: 05/28/2004
  • Published: 11/10/2005
  • Est. Priority Date: 05/06/2004
  • Status: Active Grant
First Claim
Patent Images

1. A method for using an index that is hash-partitioned to access a table that is not hash-partitioned, the method comprising:

  • receiving a request at the database system to perform an operation involving a table in the database; and

    if performing the operation involves looking up a key in the hash-partitioned index, the method further comprises;

    applying a hash function to the key to identify a unique partition within the hash-partitioned index for the key; and

    using the key to perform a lookup in the identified partition to identify zero or more rows of the table that match the key.

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