iNDEXES kEYS

From: James Antonie Rees <tony_rees_at_dmcwave.com>
Date: Wed, 6 Feb 2002 15:59:17 -0000
Message-ID: <1013011275.10529.0.nnrp-07.d4f0f429@news.demon.co.uk>

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 Wed Feb 06 2002 - 09:59:17 CST