Information générale
Catégorie:
Codage, syntaxe et commandes
As Barbara said, this query is not Rushmore optimizable.
Just a suggestion (I have no idea if it's better): try to use
"Cover" $ name
instead of
name like "%Cover%"
It might work a little faster.
Also, you may want to take a look at PHDBase product. It can do fuzzy searches ar incredible speed.
Vlad
>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
Précédent
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