Select speed

2011-11-21 Thread Sytze de Boer
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.

Re: Select speed

2011-11-21 Thread Frank Cazabon
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

Re: Select speed

2011-11-21 Thread Stephen Russell
On Mon, Nov 21, 2011 at 2:14 PM, Sytze de Boer sytze.k...@gmail.com 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