Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Can adding an index make a non SARGable query SARGable?. Parent comment
Close - it refers to SQL Server being able to take your Search ARGuments (SARG) and do an index seek to jump to the rows you're looking for.
> Is this a sql server specific term?
No: https://dba.stackexchange.com/questions/162263/what-does-the...
> Why not just use a function index?
Microsoft SQL Server doesn't have those.
There are no comments on this comment yet.
Close - it refers to SQL Server being able to take your Search ARGuments (SARG) and do an index seek to jump to the rows you're looking for.
> Is this a sql server specific term?
No: https://dba.stackexchange.com/questions/162263/what-does-the...
> Why not just use a function index?
Microsoft SQL Server doesn't have those.