3 ms·

I had no idea what sargable was. I guess it means using an index? Is this a sql server specific term? https://www.sqlshack.com/how-to-use-sargable-expressions-i

I had no idea what sargable was. I guess it means using an index? Is this a sql server specific term? https://www.sqlshack.com/how-to-use-sargable-expressions-in-t-sql-queries-performance-advantages-and-examples/ https://www.sqlshack.com/how-to-use-sargable-expressions-in-... Why not just use a function index?

BrentOzar 7y ago
> I had no idea what sargable was. I guess it means using an index? 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-word-sargable-really-mean https://dba.stackexchange.com/questions/162263/what-does-the... > Why not just use a function index? Microsoft SQL Server doesn't have those.
deleted 7y ago
[deleted]