Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimizable expressions
Message
 
 
À
08/06/2001 17:24:54
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Divers
Thread ID:
00517247
Message ID:
00517257
Vues:
18
>If I index a file on a function like
>
>index on SqueezeDesc() tag Xdesc
>
>then query optimizations take advantage of the expression ie.
>
>select * from xFile where squeezedesc() = 'ABC' (Fully optimized)
>
>After I used STD to reindex the table the expression is no longer Rushmore optimized. What is a workaround for this problem?

I did not think that could ever be optimized. What does KEY(n) return? Does it return SqueezeDesc()?
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform