<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-schema-redundant-indexes">
      </a>
      30.4.3.27 The schema_redundant_indexes and x$schema_flattened_keys Views
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045062502672">
  </a>
  <a class="indexterm" name="idm46045062501216">
  </a>
  <a class="indexterm" name="idm46045062499712">
  </a>
  <a class="indexterm" name="idm46045062498208">
  </a>
  <p>
   The
   <a class="link" href="sys-schema-redundant-indexes.html" title="30.4.3.27 The schema_redundant_indexes and x$schema_flattened_keys Views">
    <code class="literal">
     schema_redundant_indexes
    </code>
   </a>
   view displays indexes that duplicate other indexes or are made
          redundant by them. The
   <a class="link" href="sys-schema-redundant-indexes.html" title="30.4.3.27 The schema_redundant_indexes and x$schema_flattened_keys Views">
    <code class="literal">
     x$schema_flattened_keys
    </code>
   </a>
   view is a helper view for
   <a class="link" href="sys-schema-redundant-indexes.html" title="30.4.3.27 The schema_redundant_indexes and x$schema_flattened_keys Views">
    <code class="literal">
     schema_redundant_indexes
    </code>
   </a>
   .
  </p>
  <p>
   In the following column descriptions, the dominant index is
          the one that makes the redundant index redundant.
  </p>
  <p>
   The
   <a class="link" href="sys-schema-redundant-indexes.html" title="30.4.3.27 The schema_redundant_indexes and x$schema_flattened_keys Views">
    <code class="literal">
     schema_redundant_indexes
    </code>
   </a>
   view has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       table_schema
      </code>
     </p>
     <p>
      The schema that contains the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       table_name
      </code>
     </p>
     <p>
      The table that contains the index.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       redundant_index_name
      </code>
     </p>
     <p>
      The name of the redundant index.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       redundant_index_columns
      </code>
     </p>
     <p>
      The names of the columns in the redundant index.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       redundant_index_non_unique
      </code>
     </p>
     <p>
      The number of nonunique columns in the redundant index.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       dominant_index_name
      </code>
     </p>
     <p>
      The name of the dominant index.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       dominant_index_columns
      </code>
     </p>
     <p>
      The names of the columns in the dominant index.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       dominant_index_non_unique
      </code>
     </p>
     <p>
      The number of nonunique columns in the dominant index.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       subpart_exists
      </code>
     </p>
     <p>
      Whether the index indexes only part of a column.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       sql_drop_index
      </code>
     </p>
     <p>
      The statement to execute to drop the redundant index.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <a class="link" href="sys-schema-redundant-indexes.html" title="30.4.3.27 The schema_redundant_indexes and x$schema_flattened_keys Views">
    <code class="literal">
     x$schema_flattened_keys
    </code>
   </a>
   view has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       table_schema
      </code>
     </p>
     <p>
      The schema that contains the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       table_name
      </code>
     </p>
     <p>
      The table that contains the index.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       index_name
      </code>
     </p>
     <p>
      An index name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       non_unique
      </code>
     </p>
     <p>
      The number of nonunique columns in the index.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       subpart_exists
      </code>
     </p>
     <p>
      Whether the index indexes only part of a column.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       index_columns
      </code>
     </p>
     <p>
      The name of the columns in the index.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
