Does anybody know of a way to rushmore optimize the following SQL
statement?

Select * from part where name like '%Cover%'

I have an index on name and as long as I am searching for an equality, name
= 'text', statement or LIKE 'Cover%', begins with, the SQL statement is
optimized. But if I want to search for a record where the name contains a
specified text or ends with the text, the statement is not optimized.

Any help would be greatly appreciated

Thanks --
David Wilkerson