SYS.V$REDUNDANT_INDEX
This view contains data about the redundant indexes for a table (or for all the current user's tables).
Columns
See ttRedundantIndexCheck in the Oracle TimesTen In-Memory Database Reference for information on the columns in this view, including the column name, data type, and description.
Ignore the elementId column. It is unused.