Re: newbue question: understanding indexes

Vince Laurent wrote:

> We have a report that uses a table (GLPCA) and I was asked to see if
> it used a certain field (BUKR) as a field. Well, the table has 6
> indexes: GLPCA~0 and so on...
>
> I ran the following SQL script:
> SQL> select index_name, column_name
> 2 from dba_ind_columns
> 3 where index_owner = 'SAPR3' and
> 4 index_name like '%GLPCA%'
> 5 order by index_name, column_position;
>
> And got back
>
> INDEX_NAME COLUMN_NAME
> ------------ ---------------
> GLPCA~0 RCLNT
> GLPCA~0 GL_SIRID
>
> GLPCA~1 KOKRS
> GLPCA~1 RYEAR
> GLPCA~1 RPRCTR
> GLPCA~1 RVERS
> GLPCA~1 RACCT
>
> GLPCA~2 DOCNR
> GLPCA~2 RYEAR
> GLPCA~2 DOCCT
> GLPCA~2 RBUKRS
> GLPCA~2 RLDNR
> GLPCA~2 RCLNT
> GLPCA~2 DOCLN
>
> GLPCA~3 REFDOCNR
> GLPCA~3 REFRYEAR
> GLPCA~3 REFDOCCT
> GLPCA~3 RBUKRS
> GLPCA~3 RLDNR
> GLPCA~3 REFDOCLN
> GLPCA~3 RCLNT
>
> GLPCA~7 RHOART
> GLPCA~7 KOKRS
> GLPCA~7 RYEAR
> GLPCA~7 ACTIV
> GLPCA~7 POPER
>
> As you can see, the field appears in an index
> GLPCA~2 RBUKRS
>
> But the index also has many other fields. So how can I answer the
> question: "Can you tell if GLPCA is index by BUKR?" Apparently there
> is a report that uses that field a lot.
>
> How does a table use an index that has more than 1 key in it?
>
> Thanks!

Explain plan.

You can find information on how to use it at http://technet.oracle.com.

Daniel Morgan Received on Fri Jul 05 2002 - 14:43:17 CDT