Definitions

from Wiktionary, Creative Commons Attribution/Share-Alike License.

  • adjective computing, databases Able to use indexes to speed up execution.

Etymologies

from Wiktionary, Creative Commons Attribution/Share-Alike License

Blend of search,‎ argument, and able

Support

Help support Wordnik (and make this page ad-free) by adopting the word sargable.

Examples

  • MBRIntersects function (which just checks intersection of two boxes without splitting them into start and end points) is sargable too and the query above is quite overcomplicated.

    Planet MySQL 2010

  • Since there is no sargable condition that would find out which range starts earlier, we'll just need to check both ways.

    Planet MySQL 2010

  • Since there is no sargable condition that would find out which range starts earlier, we'll just need to check both ways.

    Planet MySQL Quassnoi 2010

  • MBRIntersects function (which just checks intersection of two boxes without splitting them into start and end points) is sargable too and the query above is quite overcomplicated.

    Planet MySQL Quassnoi 2010

  • The reason why it's the best way to write the query this wayis because it is sargable.

    ASP.NET Forums 2009

  • I encourage you to do a google search on "SQL Server sargable" and read the first article or two that comes up in the list.

    ASP.NET Forums 2009

  • Yeah, sadly I know DBAs who can't write sargable queries as well.

    SQLblog.com - The SQL Server blog spot on the web 2009

  • The reason why it's the best way to write the query this wayis because it is sargable.

    ASP.NET Forums 2009

  • Yeah, sadly I know DBAs who can't write sargable queries as well.

    SQLblog.com - The SQL Server blog spot on the web 2009

  • I encourage you to do a google search on "SQL Server sargable" and read the first article or two that comes up in the list.

    ASP.NET Forums 2009

Comments

Log in or sign up to get involved in the conversation. It's quick and easy.