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

Explanation

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.

Key points

The function YEAR() prevents index use on order_date
Full table scan occurs due to the function in the WHERE clause
Performance concern arises from lack of index utilization

Ready to go further?

Start full exam Practice more questions

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