Re: Which is faster?

From: Louis Cohen <louiscoh_at_sprynet.com>
Date: Fri, 1 Jan 1999 07:10:35 -0800
Message-ID: <76k0or$2k8$1_at_lore.eur.sprynet.com>


Run both with trace on (alter session set sql_trace true;), but for a fair test, run one version, then the other, and then the first one again to see the result once the data is in the buffer cache.

Then use tkprof to show the internal details of each run, and the execution plan.

Regards

Louis Cohen
San Leandro, CA

wychan wrote in message <3688F473.AB057648_at_vol.net>...
>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 Fri Jan 01 1999 - 16:10:35 CET

Original text of this message