This page describes the syntax to use SHOWSTATS command. SHOWSTATS can be used to display the statistics collected on table by an UPDATE STATISTICS statement. SHOWSTATS  can be used to get summary information about data in a table. It contains, rowcount, UEC (unique entry count) and possible skew information for all columns on which statistics has been collected, including multi-column (MC) stats. The command is also used when investigating plan quality questions.

 

    showstats for table <table name> on <columns> [detail];

<columns> can be EVERY COLUMN, EVERY KEY, or a comma-separated list of specific column names and MC groups. For example.

    showstats for table t on c1, c2, (c3,c4);

will show summary information on the histograms for columns c1 and c2, and the multi-column histogram for (c3,c4).

Without the 'detail' keyword, only the number of intervals and the overall row count and UEC for each histogram are shown. With 'detail', it also includes information on each interval of the requested histograms. In the output intervals is abbreviated as Ints, and histogram_id is an internal id used to denote that histogram associated with a particular column or MC group. The boundary value displayed with the detailed histograms is the highest value included in that interval, except for interval 0, the boundary value of which is the lowest value overall.

This information was provided by Barry Fritchman.

Content by label

There is no content with the specified labels