>Well, it will be
>
>FieldName LIKE '%[.]ext'
>
>This will be non-sargable, so if you can create a computed column for extension and index on it, the performance will be better.
Thanks, I have additional integer index that are part of the query. So, this short out the result to about 10 to 20 records at most. If I add a condition like this, it should be pretty much fast I guess.
What is non-sargable?