Re: Which is faster?
From: Ashok Upadhyay <aupadhya_at_earthlink.net>
Date: Tue, 29 Dec 1998 17:21:01 GMT
Message-ID: <36890E2E.CC6A845F_at_earthlink.net>
Date: Tue, 29 Dec 1998 17:21:01 GMT
Message-ID: <36890E2E.CC6A845F_at_earthlink.net>
In my opinion
Depends which column has index and which not or which column is the
first column of a composite index.
Hope that helps
wychan wrote:
> Which of the following select statement is running faster:
>
> select * from table_a, table_b
> 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 - 18:21:01 CET