![Start of change](KC_ROOT/images/ddita/delta.gif)
Hash access (ACCESSTYPE='H', 'HN', or 'MH')
The ACCESSTYPE column in the plan table has a value of 'H', 'HN', or 'MH', when the table being accessed is organized by hash, and hash access is used to access the data.
![Begin program-specific programming interface information.](../cmn/../art/pspi_opn.gif)
When a hash access path is selected for a parallel group, parallelism is not selected for that parallel group, however DB2® might select parallelism for other parallel groups in the query.
When star join is enabled, DB2 does not use hash access for either the fact or dimension tables when a query contains a qualified star join.
![End program-specific programming interface information.](../cmn/../art/pspi_cls.gif)
![End of change](KC_ROOT/images/ddita/deltaend.gif)