Re: Why this query is sooo slow?!

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 25 May 2004 20:02:23 +0100
Message-ID: <40b3981b$0$20515$cc9e4d1f@news-text.dial.pipex.com>

"JZ" <ibm_97_at_yahoo.com> wrote in message news:10bc841c.0405250709.7d873535_at_posting.google.com...
> For the same tables with the same data size and indexes on a PC(not a
> server), it took 45 SECONDS for Sybase 12.5.1 ASE for Linux to run the
> same query.
>
>
> BTW, on the same PC which Sybase runs, it took Oracle 10g 20 minutes.
>
> Oracle sucks?

No. Oracle is misconfigured in some way or the tests are not comparable. Oracle is not, as a general rule, 20x slower than the competition.

If this is for a benchmarking exercise, post the details, if it is query/performance help then do as srivenu suggested and trace the query and see where the time is being eaten.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Received on Tue May 25 2004 - 14:02:23 CDT