Hi Steven,
the speed of the query depends on whether you have the correct index tags or not. With the right index tags, most queries will be extremely fast.
To create an index FILE, you issue INDEX ON xxx TO yyy, to create an index TAG you issue CREATE ON xxx TAG yyy. The latter is what you usually do, because the created CDX file is automatically opened whenever you use a table. For index files you must always make sure that they are opened yorself, it does not happen automatically.
>What is the difference in Index and Order?
>
>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.