Re: how to view all the index

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/02/13
Message-ID: <5dtlqg$mrr$2@newton.pacific.net.sg>#1/1

cscywong_at_ug.cs.ust.hk (Wong Chung Yin) wrote:
>Hi,
> if i want to know how many index created on a table, what should I do?

Hi there,

Use the following statement

select * from user_indexes where table_name = 'your table name'

This will give you the number of indexes on the table.

If you need to know the column on which the indexes are created, then use the following statement

select * from user_ind_columns where table_name = 'your table name' and index_name = 'index name from the above query'

Regards

N.Prabhakar Received on Thu Feb 13 1997 - 00:00:00 CST