Re: Why index does not matain the order ?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 05 Jul 2002 16:21:20 GMT
Message-ID: <3D25C758.BC0129EA@exesolutions.com>

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) */
>
> 2> CCIAWD, TICOWD, NUCOWD, CUENWD, CAUXWD from TIGSA_DCW10
>
> 3> ;
>
> CC TICOWD NUCOWD CUENWD CAUXWD
>
> -- ---------- ---------- --------------- --------
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 600000 02ADM
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 600000 01COM
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 700000 01APR
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 600000 02APR
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 600000 02ADM
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 600000 01COM
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 600000 02ADM
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 700000 01APR
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 769000
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 408000 002
>
> C3 22 56767 600000 02APR
>
> C3 22 56767 408000 001
>
> 62 filas seleccionadas.
>
> WITH ORDER BY OK !!
>
> SQLWKS> select /*+ index(TIGSA_DCW10 TIGSA_DCW10L) */
>
> 2> CCIAWD, TICOWD, NUCOWD, CUENWD, CAUXWD from TIGSA_DCW10 order by CCIAWD,
> TICOWD, NUCOWD, CUENWD, CAUXWD
>
> 3>
>
> CC TICOWD NUCOWD CUENWD CAUXWD
>
> -- ---------- ---------- --------------- --------
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 001
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 002
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 003
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 004
>
> C3 22 56767 408000 005
>
> C3 22 56767 408000 005
>
> C3 22 56767 408000 005
>
> C3 22 56767 408000 005
>
> C3 22 56767 408000 005
>
> C3 22 56767 408000 005
>
> C3 22 56767 408000 005
>
> C3 22 56767 408000 005
>
> C3 22 56767 408000 005
>
> C3 22 56767 408000 005
>
> C3 22 56767 600000 01COM
>
> C3 22 56767 600000 01COM
>
> C3 22 56767 600000 02ADM
>
> C3 22 56767 600000 02ADM
>
> C3 22 56767 600000 02ADM
>
> C3 22 56767 600000 02APR
>
> C3 22 56767 600000 02APR
>
> C3 22 56767 700000 01APR
>
> C3 22 56767 700000 01APR
>
> C3 22 56767 769000

You apparently have a misunderstanding about how data is stored in tables and what indexes do. Neither one has the slightest thing to do with the ordering of data.

If you want an ordered output you use the ORDER BY clause.

Daniel Morgan Received on Fri Jul 05 2002 - 11:21:20 CDT