Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
By the way... I'd like to ask.. what do you think
INDEX ON Upper(Description) TAG Test1
INDEX ON "1"+UPPER(Description) TAG Test2
SELECT * FROM table WHERE "1"+UPPER(Description) LIKE "1%X%C" INTO ARRAY laResult
Take 30 seconds...
SELECT * FROM Table WHERE UPPER(Description) LIKE "%X%C" INTO ARRAY laResult
Take 27 seconds...
SELECT * FROM Table WHERE UPPER(Description) LIKE "X%C" INTO ARRAY laResult
Take 4 second....!!!
In 3-rd case - it same "Partial" but speed of query realy nice... is there some trick to avoid lead "%"
in expression... or no chances?
Thanks again
Denis
>>Fabio,
>>Thank you.
>>Its realy displays FULL in VFP9.. but in VFP8S1 its always "partial" or "none"..
>>In my case I need to use "X%C" expression.. and here no chance to get it optimized.. but in any case - your message was very usefull for me.
>>
>ignore the
>>Denis.
>>
>
>The messages of SYS(3054) they are indicative only,
>there are many cases where 'partial' or 'none' it results completely optimized,
>or the SELECT is more rapids of a version 'full'
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