Indexed table?

[aph]

Hi,

How we know that, the table is indexed?

Please help.

[sambavan]

   SELECT index_name. column_name 
    FROM user_ind_columns
    WHERE table_name IN ('tab1','tab2','tab3');

Or

you can use the view USER_INDEXES to get more information, like whether they are unique and etc.

To learm more about the USER_INDEXES column names do

 desc USER_INDEXES

Hope this would help ou.

Sam