The Date (DATE), Time (TIME), and Datetime (DTTM) index types

Three index types are used to process queries involving date, time, or datetime quantities:

• A DATE index is used on columns of data type DATE to process certain queries involving date quantities.

• The TIME index is used on columns of data type TIME to process certain queries involving time quantities.

• The DTTM index is used on columns of data type DATETIME or TIMESTAMP to process certain queries involving datetime quantities.