What does the following query return and what performance concern does it raise? SELECT * FROM orders WHERE YEAR(order_date) = 2023

Question

SQL Fundamentals — Hard

What does the following query return and what performance concern does it raise? SELECT * FROM orders WHERE YEAR(order_date) = 2023

Accepted Answer

The query returns orders placed in 2023 but the use of the YEAR() function prevents the index on order_date from being utilized, leading to a full table scan which can impact performance.