RE: Performance aka. Table Joins

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

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Limin Guo
Sent: Friday, May 26, 2006 2:53 PM
To: jkstill_at_gmail.com
Cc: mwf_at_rsiz.com; breitliw_at_centrexcc.com; genegurevich_at_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_at_gmail.com <mailto:jkstill_at_gmail.com> > wrote:

On 5/25/06, Mark W. Farnham < mwf_at_rsiz.com <mailto:mwf_at_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.

--

http://www.freelists.org/webpage/oracle-l Received on Fri May 26 2006 - 15:25:59 CDT