December 15, 2017 at 9:50 pm
Hi All,
What is the difference between Selectivity and SARGAbility?
Thanks,
Sam
December 16, 2017 at 5:02 am
https://www.sqlinthewild.co.za/index.php/2015/10/06/index-selectivity-and-index-scans/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 16, 2017 at 9:16 pm
Thanks Gail. Any thoughts on the term SARGable? I feel the word SARGable means "Searchable" based on condition or not. Is that correct?
December 17, 2017 at 1:31 am
From the blog post:
A seek requires a predicate and that predicate must be of the form that can be used as a search argument (SARGable)
It's a recursive term. A predicate is SARGable if it is of the form that can be used for an index seek operation.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 17, 2017 at 10:59 pm
Thank you Gail.
December 18, 2017 at 7:44 am
The old school definition of the term is "Search Argument Able", shortened to Sargeable. Gail's definition of the function of the term, as usual, is spot on.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy