Hash access on tables

You can use hash access to optimize data access for certain kinds of tables.

If you are involved in the physical design of a database, you work with other designers to determine when to enable hash access on tables.

The main purposes of hash access is to optimize data access. If your programs regularly access a single row in a table and the table has a unique identifier for each row, you can use hash access to directly retrieve the data from individual rows. Hash access requires that tables have at least one column with values that are unique to each row.