> 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 i

> 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.