Re: ORDER BY and performances

Hello Alexandre,

Try:

    SELECT * FROM Articles
    where ArticleCode >= ' '
    ORDER BY ArticleCode

The singe space will force the user of the index. If articeCode is numeric, try;

    where ArticleCode >= 0

Cheers, Roelof

R. Schierbeek, DBA
email : info_at_bytelife.com
www : www.bytelife.com/sql4dba.htm

> Alexandre Guillien <aguillien_at_tetraconcept.com> wrote in message
> news:39EC79D2.F7762323_at_tetraconcept.com...
> > Hello,
> >
> > I am asking myself questions whether I am stupid or Oracle has a very
> > weak point.
> >
> > I use Oracle 8.1.6. I have a table : Articles with several fields,
> > including ArticleCode and a unique index on ArticleCode. There are also
> > several other indexes for other purposes.
> > The table has currently 30.000 records.
> >
> > When I do : SELECT * FROM Articles ORDER BY ArticleCode, the query is
> > more than 60 seconds long.
> >
> > I did some Analyze Table and Analyze Index but it didn't change
> > anything. The Explain Plan always sends me a most stupid plan ... and
> > the query is still very slow ...
Received on Mon Nov 13 2000 - 13:44:06 CST