Re: iNDEXES kEYS

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 7 Feb 2002 06:00:36 +1100
Message-ID: <3c617d5b$0$18470$afc38c87@news.optusnet.com.au>

Of course, if a proper index naming convention had been adopted, you'd be able to tell what columns were involved purely from the index name.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Murali" <oraclems_at_hotmail.com> wrote in message
news:22e6597b.0202061012.cd9d708_at_posting.google.com...


> > Now I need to interrogate the index

> > itself to see what field the index keys are.

>

> It is DBA_IND_COLUMNS

>

> Murali

> http://www.dbaquest.com/

Received on Wed Feb 06 2002 - 13:00:36 CST