Advantages and Disadvantages of DATE/DTTM

Queries with date, time, or datetime quantities are resolved more quickly than with other index types.

You can create and drop a DATE or DTTM index.

Uses more disk space than HNG index.

Fast equality still requires LF or HG index.

You can use these indexes only if data in the column is DATE, DATETIME, or TIMESTAMP data type.