Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to view all the index

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US