Re: Simple SELECT taking long time...

From: Niall <n-litchfield_at_audit-commission.gov.uk>
Date: 2000/03/02
Message-ID: <89m17f$l8g$1@soap.pipex.net>#1/1

"Bandoba" <bandoba_at_yahoo.com> wrote in message news:sbo7jq76jp66_at_corp.supernews.com...
> Hi,
>
> I am firing a SQL which looks like
>
> SELECT DISTINCT Col1, Col2, ..., Col10
> FROM TableName
> ORDER BY Col5 DESC, COL2 DESC, Col1 DESC
>
> Basically there is no WHERE clause and there are no joins with any other
> table. That table contains 69000 rows. My database server is Oracle 8
> running on Sun Solaris 2.6 (on Sparc Ultra 10). Following are different
> connection methods I used and the results.

what is performance like without the order by clauses? If it is fast then it sounds like your sort_area_size may be too small

HTH Received on Thu Mar 02 2000 - 00:00:00 CST