Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL, Indexes and Rushmore
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00202421
Message ID:
00202562
Views:
13
I don't think this is true. For Rushmore to take effect, you need to match the index expression EXACTLY. In this case, if an index expression is based on the concatenation of two fields, the where or for clause also needs to concatenate the expression. Otherwise, VFP will not be able to find the correct index expression to use.

In terms of creating one bitmap versus two, I think this issues is all that relevant. Matching the index expressions and having a deleted tag on the other hand, is....

>>You might see a bit better performance from the compound index because VFP creates a bitmap with a bit for each record in the file and a 1 for each record that matches the index and a 0 for each one that doesn't. For two indexes it has to create two bitmaps and then AND them together to figure out which records match.
<<
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform