Re: how to view all the index

From: Sanjeev Parikh <sanj_at_compuserve.com>
Date: 1997/02/12
Message-ID: <01bc191d$2b0c3ea0$9d1ee8c3@sanj-home>#1/1

Hi Wong,

Say for instance the user is SCOTT and the table you want to find the index on is called EMP you can
run the following query:-

                select   index_name, column_name
                from     dba_ind_columns
                where    index_owner = 'SCOTT'  and    index_name = c_ind
and  table_name = 'EMP'
                order   by column_position;

Sanjeev Parikh
London UK.

Wong Chung Yin <cscywong_at_ug.cs.ust.hk> wrote in article <5dopts$n3n_at_ustsu10.ust.hk>...
> Hi,
> if i want to know how many index created on a table, what should I do?
>
Received on Wed Feb 12 1997 - 00:00:00 CST