7 Oct
2005
7 Oct
'05
9:13 p.m.
"Calum Grant" <calum@visula.org> 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? Regards, Arkadiy