Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I need more speed
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00265201
Message ID:
00266971
Views:
21
>>35,000 records
>>set filter to fielda = a and fieldb = b and fieldc = c
>>indexes on major fields
>>
>>for the filter I have an index like this:
>>index on fielda+fieldb+fieldc tag tag1
>>
>>Thanks for your suggestions
>>
>Jeff,
>
>Your index is wrong for Rushmore. You need three indexes one each for fielda, fieldb, and fieldc.

Or he needs to match the existing index:

fielda+fieldb+fieldc=a+b+c
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform