Histogram displays

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

Table 6-7: 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