The Date (DATE), Time (TIME), and Datetime (DTTM) Index Types

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

• Recommended Use of DATE, TIME, and DTTM Index Types
  Use a DATE, TIME, or DTTM index in the following cases, when the DATE, TIME, DATETIME, or TIMESTAMP column is used in queries containing date and time functions and operations.
• Advantages and Disadvantages of DATE/TIME/DTTM
  See the following table for advantages and disadvantages of using a DATE, TIME, or DTTM index.
• Comparison to Other Indexes
  The DATE, TIME, and DTTM indexes have performance consistent with the HNG index.
• Additional Indexes
  It is recommended to always have a DATE, TIME, or DTTM index on a column of DATE, TIME, DATETIME, or TIMESTAMP data type, if the column is referenced in the WHERE clause, in ON conditions, or in the GROUP BY clause.