- enables the [[Database Engine]] to take full advantage of an existing [[Database Indexes|Database Index]] to speed up data retrieval - to write sargable queries: - avoid using functions or calculations on [[Database Indexes|Indexed]] cols in WHERE clause - use direct comparisons when possible - if you need to use a function on a column: - create a computed column, or a function based index - (if your DB system supports it) https://en.wikipedia.org/wiki/Sargable https://www.youtube.com/watch?v=BHwzDmr6d7s&list=PLCRMIe5FDPsdnSszazqVIQFh99t1ExH19&index=5