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.
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 |