On Mar 7, 2006, at 10:50, jimbehr3446 wrote:

> That is certainly what we are observing. It's too bad it is not smart
> enought to realize there are no ordering clauses and quit when it has
> the desired number of records.

Especially if one is trying to do sampling of the table. Consider
the query

select * from table where rand() < .01;

to sample a table. Ideally, this would just create a stream of rows
and throw out 90% of them. Does FB actually have to instantiate the
(potentially humongous) table here too?

Richard Wesley
hawkfish tableausoftware com