<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-column-statistics-table">
      </a>
      28.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045080067712">
  </a>
  <p>
   The
   <a class="link" href="information-schema-column-statistics-table.html" title="28.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table">
    <code class="literal">
     COLUMN_STATISTICS
    </code>
   </a>
   table provides
      access to histogram statistics for column values.
  </p>
  <p>
   For information about histogram statistics, see
   <a class="xref" href="optimizer-statistics.html" title="10.9.6 Optimizer Statistics">
    Section 10.9.6, “Optimizer Statistics”
   </a>
   , and
   <a class="xref" href="analyze-table.html" title="15.7.3.1 ANALYZE TABLE Statement">
    Section 15.7.3.1, “ANALYZE TABLE Statement”
   </a>
   .
  </p>
  <p>
   You can see information only for columns for which you have some
      privilege.
  </p>
  <p>
   The
   <a class="link" href="information-schema-column-statistics-table.html" title="28.3.11 The INFORMATION_SCHEMA COLUMN_STATISTICS Table">
    <code class="literal">
     COLUMN_STATISTICS
    </code>
   </a>
   table has these
      columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       SCHEMA_NAME
      </code>
     </p>
     <p>
      The names of the schema for which the statistics apply.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_NAME
      </code>
     </p>
     <p>
      The names of the column for which the statistics apply.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COLUMN_NAME
      </code>
     </p>
     <p>
      The names of the column for which the statistics apply.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       HISTOGRAM
      </code>
     </p>
     <p>
      A
      <a class="link" href="json.html" title="13.5 The JSON Data Type">
       <code class="literal">
        JSON
       </code>
      </a>
      object describing the
          column statistics, stored as a histogram.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
