Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DESC clause in INDEXes
Of course, it does not change the default order by that would drive people
crazy! It is good for when you are ordering by desc and then the optimizer
might choose to use the index to retrieve the data.
Jim
"philou" <pbo_at_ifrance.com> wrote in message news:aecj3d$9lv$1_at_wanadoo.fr...
> Who could tell me what are the consequences of a DESCending clause in an
> index (Oracle 8i)?
> ex : CREATE INDEX I_CUSTOMER ON CUSTOMER (CUSTOMER_ID DESC)
>
> It does NOT change the default sort order of ORDER BY clauses, whereas one
> should have thought it would!
>
>
>
Received on Fri Jun 14 2002 - 07:19:01 CDT