Automatic Rewrite of Date and Time Ranges The following chart shows which DBMS rewrites where clause expressions that access the year part of a date or timestamp (or the like) into a range expression such as ts >= DATE'2024-01-01' AND ts < DATE'2025-01-01'. This enables the use of a sort-based index on the ts column. Unconditionally rewritten — even if only a matching function-based index exists The yellow check marks mean that the rewrite is always done—even if there was a function-b...
