Re: how to view all the index

Wong Chung Yin wrote:
>
> Hi,
> if i want to know how many index created on a table, what should I do?

Wong:

This should do the trick.

select index_name from all_indexes where table_owner = 'owner' and table_name = 'table';

John Hough Received on Tue Feb 11 1997 - 00:00:00 CST