发明名称 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
摘要 One embodiment of the present invention provides a system that uses an index that is hash-partitioned to access a table that is not hash-partitioned. During system operation, the database receives a request to perform an operation involving a table in the database. If performing the operation involves looking up a key in the hash-partitioned index, the database applies a hash function to the key to identify a unique partition within the hash-partitioned index for the key, and uses the key to perform a lookup in the identified partition to identify zero or more rows of the table that match the key.
申请公布号 US8583657(B2) 申请公布日期 2013.11.12
申请号 US20040857650 申请日期 2004.05.28
申请人 SHUKLA VIKRAM;ORACLE INTERNATIONAL CORPORATION 发明人 SHUKLA VIKRAM
分类号 G06F17/30;G06F7/00 主分类号 G06F17/30
代理机构 代理人
主权项
地址