>>
>>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.
Why then when I SELECT ... in command window all tables involved in SELECT stay open in Data Session window, but if I opened them before SELECT the same tables appear in Data Session window, nothing more?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.