<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-schema-unused-indexes">
      </a>
      30.4.3.32 The schema_unused_indexes View
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045062267712">
  </a>
  <a class="indexterm" name="idm46045062266208">
  </a>
  <p>
   These views display indexes for which there are no events,
          which indicates that they are not being used. By default, rows
          are sorted by schema and table.
  </p>
  <p>
   This view is most useful when the server has been up and
          processing long enough that its workload is representative.
          Otherwise, presence of an index in this view may not be
          meaningful.
  </p>
  <p>
   The
   <a class="link" href="sys-schema-unused-indexes.html" title="30.4.3.32 The schema_unused_indexes View">
    <code class="literal">
     schema_unused_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">
       object_schema
      </code>
     </p>
     <p>
      The schema name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       object_name
      </code>
     </p>
     <p>
      The table name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       index_name
      </code>
     </p>
     <p>
      The unused index name.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
