Subject Which is faster? Select First 3000 or MaxRows = 3000 ?
Author Andrew
I have a table containing just 8 fields, however there may be upto
several million data records within this table.

I need to bring the record set back in batches of approx 3000 records.

I'm using an IB_Query and was hoping someone could advise if it is
quicker/more efficient to use the following SQL statement or set the
MaxRows property on the query.

Select First 3000 * From MYTABLENAME
WHERE ......

many thanks