Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimizable expressions
Message
From
08/06/2001 17:24:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Stonefield
Title:
Optimizable expressions
Miscellaneous
Thread ID:
00517247
Message ID:
00517247
Views:
54
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?
Next
Reply
Map
View

Click here to load this message in the networking platform