Xref: alice comp.databases.oracle.tools:19936
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!sunqbc.risq.qc.ca!news-hub.interserv.net!news.eur.sprynet.com!not-for-mail
From: "Louis Cohen" <louiscoh@sprynet.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: Which is faster?
Date: Fri, 1 Jan 1999 07:10:35 -0800
Organization: Sprynet News Service
Lines: 31
Message-ID: <76k0or$2k8$1@lore.eur.sprynet.com>
References: <3688F473.AB057648@vol.net>
Mime-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3

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@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
>