Performance issue with Oracle 8i : order by

From: PPN <ppn_at_mederic.fr>
Date: 25 Mar 2003 08:04:11 -0800
Message-ID: <6f6a7f59.0303250804.6bac4916@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. Received on Tue Mar 25 2003 - 10:04:11 CST