>
>If you just use SELECT - SQL there is no need to set order, recommendation for Rushmore Optimization is the table not to have order. But if you want just want to SEEK you need to point the order, no metter how, If you don't the current order is used.
>:o)
>I don't know if you uderstand something from this explanation, I hardly understand myself :o)))
>Check
Using Rushmore Query Optimization to Speed Data Access in HELP for more valuable info.
A SELECT - SQL doesn't use already open tables so it's irrelevant if they have order set or not.
--sb--