Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore optimization and SELECT DISTINCT
Message
From
09/12/1997 23:32:50
 
 
To
09/12/1997 16:49:21
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00064798
Message ID:
00064892
Views:
32
>
>IMHO, Rushmore is about 'Where' expressions, i.e. field list is rushmore-irrelevant. I think, the first internal step is collect all records by joint criteria (here Rushmore used), and then Fox looks at field list.

OK,
but I my opinion Rushmore SHOULD be about using existing indexes to achieve the fastest query performance possible.

To ignore UNIQUE index tags is a waste and to be able to beat the performance of SQL by an order of magnitude
with old style xbase code is crazy.
__________________________________________________
Mesa Vista Software (david@mesa-vista.com)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform