Re: Find Index definition for an Oracle table

From: OraCLeDbA <oracle_dba_at_zdnetmail.com>
Date: Wed, 26 Aug 1998 20:44:15 -0700
Message-ID: <6s2kds$2cr@dfw-ixnews7.ix.netcom.com>

Try the following,

select a.column_name "Name of the Column", a.position "Position in the Index",
a.index_name "Name of the Index", b.uniqueness "Uniqueness"

from user_ind_columns a, user_indexes b
where a.index_name=b.index_name
where a.table_name =' XXX'

order by a.index_name, a.position;

This query will give you the type (unique/not unique) of the index, the number of columns in that index etc.

OraCLeDbA =>

timbedow_at_my-dejanews.com wrote in message <6s2dl5$qip$1_at_nnrp1.dejanews.com>...
>I need to know how to find an index definition for an Oracle table. I see
it
>in user_indexes, but I want to know which columns it is indexing.
>Specifically, I want to know if a specific column is indexed within a
table.
>
>Please respond to the email below ASAP!
>
>TIA,
>
>Tim.
>tim.bedow_at_NO_SPAMps.net
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Aug 26 1998 - 22:44:15 CDT