Re: iNDEXES kEYS

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Thu, 07 Feb 2002 19:43:52 GMT
Message-ID: <3c62d8ca.5110375@news.jaapwvandijk.myweb.nl>

If I can't remember the name of the view I'm looking for I always check the view DICT.

Jaap.

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
>
>
>
>
Received on Thu Feb 07 2002 - 13:43:52 CST