(Paul White) Searching string data for an arbitrary substring match can be an expensive operation in SQL Server. Queries of the form Column LIKE ‘%match%’ cannot use the seeking abilities of a b-tree index, so the query processor has to apply the predicate to each row individually.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help