Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

RE: Performance aka. Table Joins

Mark W. Farnham

2006-05-26

Replies:

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

 

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Limin Guo
Sent: Friday, May 26, 2006 2:53 PM
To: jkstill@gmail.com
Cc: mwf@rsiz.com; breitliw@centrexcc.com; genegurevich@discoverfinancial.com; 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@gmail.com> wrote:

 

On 5/25/06, Mark W. Farnham <mwf@rsiz.com> 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.

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.