I using a statement with LIKE in the WHERE clause. Searching for rows
containing a prefix (LIKE yPrefix% SQL Server seeks the index on that
column that fine. But if I want to search for a suffix (LIKE MySuffix
an Index Scan is used and takes very long. Do I have any possibility that SQL
Server does an Index Seek in case of LIKE MySuffix
How can I optimize such a query?
I also couldn find a use of FTS in this case, because CONTAINS only
Thank you all!