Take the 2-minute tour ×  By definition (at least from what I've
seen) sargable means that a query is capable of having the query
engine optimize the execution plan that the query uses. I've
tried looking up the answers, but there doesn't seem to be a lot
on the subject matter. So the question is, what does or doesn't
make an SQL query sargable? Any documentation would be greatly
appreciated.  For reference: Sargable  share|improve this
question +1 for "sargable". That's my word of the day for today.
:-p –  BFree Apr 28 '09 at 20:03 I might also add to Adam's
answer, that the mountains of information are in most cases
extremely particular to each DB engine. –  hoagie Apr 28 '09 at
20:05 SARG = Search ARGument. Funny thing is: "SARG" in German
means "Coffin", so I always have to smile when folks talk about
SARGABLE - able to be put in a coffin? :-) –  marc_s Apr 28 '09
at 20:31 sargability depends on your environment. MySQL's is
documented here: dev.mysql.com/doc/refman/5.0/en/mysql-
indexes.html –  Frank Farme