Queries with DATEPART function ranges or IN list predicates are now converted into queries with range predicates on DATE, TIME, or DATETIME columns or DATEPART equality predicates, so that the optimizer can use DATE, TIME, and DTTM indexes to process the queries. For more information on queries that match the criteria for this performance improvement, see the section “The Date (DATE), Time (TIME), and Datetime (DTTM) index types” in Chapter 6, “Using Sybase IQ Indexes” of the Sybase IQ System Administration Guide.
