Re: Oracle 8.0: select * with order by lasts too long

From: Hariharan Vijay <vharih1_at_gl.umbc.edu>
Date: 2000/07/26
Message-ID: <Pine.SGI.4.21L.01.0007261540140.1351260-100000@irix2.gl.umbc.edu>#1/1

Try to increase your sort-area-size.

-vijay

On Wed, 26 Jul 2000, holders wrote:

> because you're doing a 'SELECT *' it will read the whole table and not
> use the index. Without the ORDER BY it will not need to do a sort, it
> simply reads to sends it.
>
> SH
>
> Bernd Rosenau wrote:
>
> > Hello,
> >
> > the following statement needs 20 seconds for execution when run on a
> > 65000 rows table:
> >
> > select * from folders order by selekt_nr1
> >
> > Selekt_nr1 is an index-field but Oracle does not seem to use the
> > index.
> >
> > Without the ORDER BY i get an almost instant response.
> >
> > Any ideas ?
> >
> > Many thanks in advance for your help,
> >
> > Regards, Bernd
>
>

---

"When every situation which life can offer is turned to the profit of spiritual growth, no situation can really be a bad one." - Paul Brunton

---

Vijay G Hariharan
vharih1_at_umbc.edu Received on Wed Jul 26 2000 - 00:00:00 CDT