no, SELECT - SQL is not affected by the current order of the table, only by what indexes are available and if they match your filtering/joining clauses
Frank. Frank Cazabon On 21/11/2011 04:14 PM, Sytze de Boer wrote: > Hello foxers > Probably a dumb question but I'll risk it > > If I have a large history file indexed on a number (9) fields > e.g. CLIENT, STOCKCODE etc > > If I issue command SELECT FLD1, FLD2, FLD3, FROM MYTABLE etc, does it > matter which ORDER is set if I want a range of clients, or a range of stock > codes. > i..e should I issue a line that says SET ORDER TO 1 or 2 or 3 > > S > > > > > > > > > > > > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
