Histogram displays

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

Table 2-5: Commands that create histograms

Command

Histogram for

create index

Leading column only

update statistics

table_name or index_name

Leading column only

column_list

Leading column only

update index statistics

All indexed columns

update all statistics

All columns