Which is faster?

From: wychan <wychan_at_vol.net>
Date: Tue, 29 Dec 1998 23:25:39 +0800
Message-ID: <3688F473.AB057648_at_vol.net>

[Quoted] [Quoted] Which of the following select statement is running faster:

select * from table_a, table_b
[Quoted] where table_a.column_1 = table_b.column_1 and table_a.column_2 > 10;

select * from table_a, table_b
where table_a.column_2 > 10
and table_a.column_1 = table_b.column_1

Or they are homogenous?

Thanks for any advice,
River
novice DBA Received on Tue Dec 29 1998 - 16:25:39 CET