Advantages and disadvantages of DATE/TIME/DTTM

See the following table for advantages and disadvantages of using a DATE, TIME, or DTTM index.

Table 6-10: DATE/TIME/DTTM advantages/disadvantages

Advantages

Disadvantages

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

You can create and drop a DATE, TIME, 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, TIME, DATETIME, or TIMESTAMP data type.


Restrictions on DATE/TIME/DTTM indexes

The following restrictions currently apply to DATE, TIME, and DTTM indexes: