Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 43.1Mb
PDF (A4) - 43.2Mb
Man Pages (TGZ) - 295.4Kb
Man Pages (Zip) - 400.6Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb
Excerpts from this Manual

MySQL 8.0 Reference Manual  /  ...  /  The schema_redundant_indexes and x$schema_flattened_keys Views

30.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:

  • table_schema

    The schema that contains the table.

  • table_name

    The table that contains the index.

  • index_name

    An index name.

  • non_unique

    The number of nonunique columns in the index.

  • subpart_exists

    Whether the index indexes only part of a column.

  • index_columns

    The name of the columns in the index.