Subject Re: another make my query faster question
Author markd_mms
you're right it wasn't the right plan. i must have executed a query
changed the sql and used the plan for the original query but copied
the changed sql into the post.

ok so like and containing don't use indexes which is where the
difference will be.