Re: Performance issue with Oracle 8i : order by

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 25 Mar 2003 22:44:07 -0000
Message-ID: <3e80dbf1_2@mk-nntp-1.news.uk.worldonline.com>

"PPN" <ppn_at_mederic.fr> wrote in message
news:6f6a7f59.0303250804.6bac4916_at_posting.google.com...
> Hello.
>
> I'm experiencing some strange behavior.
> Using TOAD, when I run "select count(*) from (select * from my_table
> order by 1,2);", it takes 7 seconds to answer "25000". When I telnet
> the server, use SQLPLUS and run the same request, the result is
> immediate.
> Does anyone have an explanation for this ? I tried replacing TOAD by
> SQLPLUS (the client version I've got on my Windows), and same
> behavior.
>
> Thanks.
> P.

Is there a network problem? There isn't much wrong with your database; you've proved that.

Regards,
Paul Received on Tue Mar 25 2003 - 16:44:07 CST