Why index does not matain the order ?

From: Oscar <oscar_ll_at_jofre.com>
Date: Fri, 5 Jul 2002 12:29:26 +0200
Message-ID: <ag3s7t$1jl$1@nsnmrro2-gest.nuria.telefonica-data.net>

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 002

C3 22 56767 408000 003

C3 22 56767 408000 004

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 Received on Fri Jul 05 2002 - 05:29:26 CDT