Hash Access / Scan

> Database > Oracle Database

1 - About

A hash scan is used to locate rows in a hash cluster, based on a hash value. In a hash cluster, all rows with the same hash value are stored in the same data block. To perform a hash scan, Oracle first obtains the hash value by applying a hash function to a cluster key value specified by the statement. Oracle then scans the data blocks containing rows with that hash value.

db/oracle/hash_access.txt · Last modified: 2017/09/06 19:28 by gerardnico