Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Rushmore Optimizing an SQL contains statement
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement