The DATE, TIME, and DTTM indexes have performance consistent with the HNG index.
Compared to HNG, DATE, TIME, and DTTM indexes are generally up to twice as fast as HNG in the supported cases. Therefore, an HNG index is not necessary in addition to a DATE, TIME, or DTTM index on a column of DATE, TIME, DATETIME, or TIMESTAMP data type.