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.
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
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
3 matches
Mail list logo