Histogram displays

Histograms store information about the distribution of values in a column. Table 37-7 shows the commands that create and update histograms and which columns are affected.

Table 37-7: Commands that create histograms


Histogram for

create index

Leading column only

update statistics

table_name or index_name

Leading column only


Leading column only

update index statistics

All indexed columns

update all statistics

All columns