Can you provide an example of a query where indexing the base of a `CAST` is beneficial?

Consider this query: `SELECT * FROM orders WHERE CAST(order_date AS DATE) BETWEEN '2023-01-01' AND '2023-01-31';` If the `order_date` column is indexed, the database can efficiently locate orders within that date range without scanning the entire `orders` table. Without the index, it would have to examine every row.