You would like to find the indexes for a table in Oracle database.

You could find this with the following SQL using user_ind_columns view:
Select table_name, index_name, column_name,

FROM user_ind_columns

WHERE table_name= ‘My_Table_Name’;

If you want to find Column position then add column_position column in the query.

My_Table_Name is the name of the table which you would like to check the history of the statistics for.

In an SAP system you can use the report RSORADJV for this purpose or use SQL*Plus at OS level.