What is the difference in Index and Order?

to use SET INDEX You must have a disk file with the same Name i.e:

SET INDEX TO MyIndex
<PRE>
You must have MyIndex.IDX or MyIndex.CDX file
But If You create a CDX file You can have more then one ORDERs (TAGs) in it. Their names not neccessary are equal to the Name of the index file. If You have CDX file with the same name as a table it is open automaticly when You open the table i.e.
<PRE>
SELECT MyTable
INDEX ON Field1 TAG MyOrder1
INDEX ON Field2 TAG MyOrder2
INDEX ON Field3 TAG MyOrder3

That code crate ONE Index File named MyTable.CDX, but in it You have 3 different tags, so The next time You open the MyTable VFP automaticly opens & MyTable.CDX, but If You want to activate some Tag i.e. MyOrder1 You must Use SET ORDER TO MyOrder1, If You Use SET INDEX TO MyOrder1 VFP Generates error because there is no such a file MyOrder1.CDX(IDX)



What I have is a Select statement pulling records from a large table. On higher end machines this is seemless. However, on lower end machines the Running Query dialog pops up and it takes several seconds to generate.

I need the most efficient method to do this Select statement.

Here I can't help You because I don't know what is the SQL SELECT Statement, But You can use SYS(3054) function (see help for more detailed information) to see The Rushmore optimisation level.