Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore question
Message
From
29/07/2001 13:31:43
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00536979
Message ID:
00537006
Views:
10
>>>If I have an index on UPPER(Field) and then do a LOCATE FOR UPPER(Field) = lcField, does Rushmore take advantage of that index?
>>
>>Check in the help under Rushmore. You should find an entry about Rusmore optimizable expression.
>>
>>Also, look at the SYS(3054) which will tell you exactly how Rushmore is being used. It's not always safe to assume something is being optimized. Nor is always safe to assume you _want_ optimization.
>
>The SYS(3054) shows optimization levels for queries only.

Yes, of course. Sorry, it was a knee jerk reaction that crept in after the help file comment. Thanks for the catch.
Previous
Reply
Map
View

Click here to load this message in the networking platform