Re: iNDEXES kEYS

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Thu, 07 Feb 2002 04:30:09 GMT
Message-ID: <3c6202a8.80027513@news.emirates.net.ae>

On Wed, 6 Feb 2002 15:59:17 -0000, "James Antonie Rees" <tony_rees_at_dmcwave.com> wrote:

>Hi there
>
>Does anyone know which table/view or combination is used to interrogate
>database dictionary to find out what keys are associated to a specific
>index. I need to find out what index keys are already associated with a
>table so that I can plan for new indexes.
>
>ie to find what the names of the indexes are associated with a specific
>table the following code
>
>select table_name, index_name from dba_indexes
>where table_name = 'TABLE_DEMAND_DTL'
>
>This gives a list of the indices. Now I need to interrogate the index
>itself to see what field the index keys are. Am sure this is a quick one
>just can not remember
>thanks in advance
>
>regards
>
>Tony Rees
>ITD Hamilton
>DMC Stratex Networks
>
>
>
>

You can DBA_IND_COLUMNS. To get the list of Columns Asscosiated with an index.

HTH
[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Wed Feb 06 2002 - 22:30:09 CST