Is Your SQL SARGable? SQL Interview Question

follow @rebellionrider for more SQL interview question content around data analysis and performance tuning. What makes an SQL query SARGABLE? Here’s the thing. SARGABLE means Search ARGument ABLE. It simply means your SQL query is written in a way that allows the index to be used efficiently. If your WHERE condition applies a function on the column, the index usually cannot be used. Example that is NOT SARGABLE: WHERE YEAR(order_date) = 2025 Here, SQL has to calculate YEAR(order_date) for every row. That often leads to a full table scan.