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