% in the beginning of like clause

Question

I heard that its not advised to use % in the beginning of LIKE clause in SQL Server due to performance reasons.Why is this is so?

Some more details on this will help me in understanding the impact of this issue.

Answer 1

If you have % at the beginning of your clause, the query engine cannot generate a query plan that uses indexes but has to make table scans.