> However if you actually need a 'contains' search whether that be

with "LIKE"

> or "CONTAINING", an index is not used regardless. Or am I mistaken

here.

>
> regards,
> Kevin.

Hi Kevin,

An index can not help at all unless it is a starting with (or
equivalent to starting with; LIKE 'Ad%').

Select *
from Employee
where Name like 'ad%'

will use the index on name

Select *
from Employee
where Name Containing 'ad'

can not use this index, well it could, but it would need to check
every single node anyway so it would be faster to just do a table
scan.

Actually listing a few names will make it very obvious why this is.

Hope that helps
Adam