Re: Index problem with Oracle 8.0.5

Thanx for your reply .

It is exactely what I'm doing .
The problem is that I need data in descending order but I would like to access to my records without adding the 'Order by ' statement which is a very heavy process on a large amount of data . I have created an Index on the column I'm using for the order by but the option DESC on the column name of the Index seems to be ignored at creation. So if I want to have my data sorted in descending order I have two options : the 'order by' statement in my request or the creation of an Index in descending order .(that's what I think ....) Maybe I'm completely wrong ... I admit I don't know Oracle and the use of Indexes so much ...

"marc parkinson" <marcpark_at_starband.net> a écrit dans le message news: 2fKr9.5064$Df.2387243056_at_twister1.starband.net...
> You do not create an index in assending or descending order.
> The order of the query is based on an ORDER BY clause.
> The order by clause can have the desc at the end of it.
>
> Example
>
> Secect my_col
> FROM my_table
> where my_col like 'super%'
> order by my_col desc;
>
> Marc Parkinson
> Senior Oracle Engineer
>
> "Ziegler thomas" <tz_at_operon.fr> wrote in message
> news:aok6nv$233$1_at_news2adm.tiscali.fr...
> > Hi,
> >
> > Is it possible to create an index in Descending order in Oracle 8.0.5 ?
> > I've tried to add the keyword DESC after the column name but it seems to
> be
> > ignored .
> > Here is what I tried :
> > CREATE INDEX Myindex ON MyTable (MyColumn DESC) ....
> >
> > Thanx,
> > Thomas.
> >
> >
> >
>
>
>
Received on Fri Oct 18 2002 - 13:34:54 CDT