Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Descending Indexes
> I have struggled so much but couldn't find a way to create desceding
> indexes using Oracle8 and Delphi4. My problem is that I want to display
> dates in descending order and also at the same time give the facility to
> update them so cannot use queries and views don't allow order by clause.
>
> Can anybody tell help me in solving the problem
>
Oracle supports descending indexes. Refer to the sql-Manual
create index <indexname> on <tablename> (columname DESC);
But nevertheless, the index do not prepares any sorting. It only help for perfomance using that column e.g. in the select statement (e.g. in the order by clause).
And as far as I know, is a query with an order by editable (refer to the
relevant TQuery options and to the TUpdateQuery)
--
Regards
Nicolas Bronke
Received on Mon Feb 07 2000 - 05:04:24 CST