The object type: BASE TABLE , INDEX ( index_type ) , EVENT , FUNCTION , PROCEDURE , TRIGGER , VIEW . 

• count 

The number of objects in the schema of the given type. 

## 28.4.3.27 The schema_redundant_indexes and x$schema_flattened_keys Views 

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: 

• table_schema 

The schema that contains the table. 

• table_name 

The table that contains the index. 

• redundant_index_name 

The name of the redundant index. 

• redundant_index_columns 

The names of the columns in the redundant index. 

• redundant_index_non_unique 

The number of nonunique columns in the redundant index. 

• dominant_index_name 

The name of the dominant index. 

• dominant_index_columns 

The names of the columns in the dominant index. 

• dominant_index_non_unique 

The number of nonunique columns in the dominant index. 

• subpart_exists 

Whether the index indexes only part of a column. 

• sql_drop_index 

The statement to execute to drop the redundant index. 

The x$schema_flattened_keys  view has these columns: 

