> SELECT ALL <field list> FROM <tables> .... for fast full
> SELECT <field list> FROM <tables> .... for fast first

Yuk.

I think you are describing the difference between FIRST (used for sampling
data) and TOP (which processes all data, but only returns the TOP "X"
results).

Pete
===
http://www.HowToDoThings.com