sys Schema Views The object type:  BASE TABLE ,  INDEX ( index_type ) ,  EVENT ,  FUNCTION ,  PROCEDURE ,  TRIGGER , VIEW . The number of objects in the schema of the given type. The  schema_redundant_indexes  view displays indexes that duplicate other indexes or are made redundant by them. The  x$schema_flattened_keys  view is a helper view for schema_redundant_indexes . In the following column descriptions, the dominant index is the one that makes the redundant index redundant. The  schema_redundant_indexes  view has these columns: The schema that contains the table. The table that contains the index. The name of the redundant index. The names of the columns in the redundant index. The number of nonunique columns in the redundant index. The name of the dominant index. The names of the columns in the dominant index. The number of nonunique columns in the dominant index. Whether the index indexes only part of a column. The statement to execute to drop the redundant index. The  x$schema_flattened_keys  view has these columns: 5162 • sql_drop_index • subpart_exists • dominant_index_non_unique • dominant_index_columns • dominant_index_name • redundant_index_non_unique • redundant_index_columns • redundant_index_name • table_name • table_schema • count 28.4.3.27 The schema_redundant_indexes and x$schema_flattened_keys Views