Since the constant side of your where predicate is not lower case I assume you don't have a case sensitive collation. That means you could greatly increase the performance just by removing the LOWER function. Or if you do have a case sensitive collation but want all rows regardless of case you could specify an insensitive collation in your query. Either of those approaches would get rid of that nonSARGable function.