Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore Vs. Explicit Indexes
Message
From
06/04/2000 19:43:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Rushmore Vs. Explicit Indexes
Miscellaneous
Thread ID:
00356603
Message ID:
00356603
Views:
60
Is there a rule of thumb for using Rushmore as
opposed to Explicit indexes, i.e.
SELECT Customer
SET ORDER TO 0
LOCATE FOR CustId = "12345"

       vs.

SEEK "12345" ;
   IN Customer ;
   ORDER CustId
Both should yeild the same result (barring any
fat finger errors on my part in the example
above). VFP should encounter a little bit of
overhead in determining which index to use
(i.e. it's "strategy") but is there a minimum
number of records that must be in the table to
make Rushmore worth while? Is there a minimum
number of optimizable expressions? That kinda
thing.

TIA for any feedback you guys can give me.
   ...kt
Next
Reply
Map
View

Click here to load this message in the networking platform