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.