From: Arkadiy Vertleyb (vertleyb_at_[hidden])
Date: 2005-10-07 16:13:33
"Calum Grant" <calum_at_[hidden]> wrote
> // Print only 10 results
> output_results(limit(select( (my_table, my_table),
> col<0,0>() == col<1,0>() ), 10));
So, you don't seem to iterate the whole selection, only first ten results.
Since we both evaluate the expressions lazily, this doesn't look like a
right test to me. If you apply the merge-join, such a query would take the
same time on a 10-row table or on a 1000000-row table, wouldn't it?
Boost list run by bdawes at acm.org, gregod at cs.rpi.edu, cpdaniel at pacbell.net, john at johnmaddock.co.uk