“sargable” - characteristic of queries that can utilize indexes rather than table scans, thus running more efficiently; derived from a contraction of Search Argument
Amazing results may be attained when knowledge and care are applied to writing SQL queries.