What's the big deal about this FoxPro Rushmore Technology? I am
thinking about switching from CA-Clipper to FoxPro!
Rushmore is not an index type, nor is it magic as the Fox people
would have you believe. It is simply a FoxPro feature that
automatically figures out the most efficient way to use existing
indexes in a query (LOCATE, LIST, anything with a FOR clause,
etc.).
Rushmore is handy for interactive queries, but most application
developers can know ahead of time what lookups need to be done
on their database files and can arrange for an optimized lookup
the old-fashioned way with little effort.
That's why the Rushmore test results look so good but are not very
relevant to what many application developers really do. If you
are trying to write a very open-ended reporting program, on the
other hand, it may be just the ticket.