Date (DATE) and Datetime (DTTM) Indexes

DATE and DTTM index types process queries involving date or datetime quantities.

• Recommended Use of DATE and DTTM Index Types
  Use a DATE or DTTM index when the DATE, DATETIME, or TIMESTAMP column is used in queries containing date and time functions and operations.
• Advantages and Disadvantages of DATE/DTTM
  Advantages and disadvantages of using a DATE or DTTM index.
• Comparison to Other Indexes
  The DATE, TIME, and DTTM indexes have performance consistent with the HNG index.
• Additional Indexes for DATE/DTTM Columns
  Always use 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.