RE: Performance aka. Table Joins

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <lguo.oracle@xxxxxxxxx>, <jkstill@xxxxxxxxx>
  • Date: Fri, 26 May 2006 16:25:59 -0400

yep, silly me ? I was measuring the display speed, not the speed of the
query.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Limin Guo
Sent: Friday, May 26, 2006 2:53 PM
To: jkstill@xxxxxxxxx
Cc: mwf@xxxxxxxx; breitliw@xxxxxxxxxxxxx;
genegurevich@xxxxxxxxxxxxxxxxxxxxx; oracle-l
Subject: Re: Performance aka. Table Joins

Just curies, I tried it in Oracle 10.2 in a 2 way Sun V440 and got 0.39 and
0.32 respectively.

Limin.
On 5/26/06, Jared Still < jkstill@xxxxxxxxx <mailto:jkstill@xxxxxxxxx> >
wrote:

On 5/25/06, Mark W. Farnham < mwf@xxxxxxxx <mailto:mwf@xxxxxxxx> > wrote:
My system must be much slower than yours, I got 16.73 for the character and
16.93 for the numeric version.


I get 0.11 and 0.11 on an old (Dell 1750) Linux box.  :)

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist



--
Regards,

Limin Guo.

Other related posts: