Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Why index does not matain the order ?
You appear to be confusing an index with an ORDER BY clause.
An index is for finding rows quickly. An order by clause defines the
order of data returned by a select. Neither is dependent on the other;
you can ORDER BY where there is no index, and an index does not imply an
order.
Oscar wrote:
> If a make a select like:
>
> ?? WHERE IS THE ORDER ???
>
> THE INDEX is CCIAWD 1, TICOWD 2, NUCOWD 3, CUENWD 4, CAUXWD 5
> SQLWKS> select /*+ index(TIGSA_DCW10 TIGSA_DCW10L) */
-- Email address munged to avoid SPAMReceived on Fri Jul 05 2002 - 11:28:42 CDT