histograms
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| histograms [2015/10/21 10:18] – external edit 127.0.0.1 | histograms [2025/03/08 22:24] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 3: | Line 3: | ||
| The optimiser normally creates a frequency histogram if the number of distinct values in a column is less than the number of histogram buckets you specify.\\ | The optimiser normally creates a frequency histogram if the number of distinct values in a column is less than the number of histogram buckets you specify.\\ | ||
| - | This is where the histogram concentrates on only the popular values. | + | This is where the histogram concentrates on only the popular values.\\ |
| - | The less popular values are considered insignificant. | + | The less popular values are considered insignificant.\\ |
| Less popular values are therefore grouped together in a single bucket. | Less popular values are therefore grouped together in a single bucket. | ||
| ==== Hybrid Histograms ==== | ==== Hybrid Histograms ==== | ||
| As the name suggests, a combination of Height Balanced and Frequency histograms.\\ | As the name suggests, a combination of Height Balanced and Frequency histograms.\\ | ||
| 12c tends to use Hybrid Histograms instead of Height Balanced.\\ | 12c tends to use Hybrid Histograms instead of Height Balanced.\\ | ||
| - | The histogram will store the amount of times the highest value is represented in the bucket. | + | The histogram will store the amount of times the highest value is represented in the bucket.\\ |
| + | |||
| + | [[https:// | ||
histograms.1445422736.txt.gz · Last modified: 2025/03/08 22:23 (external edit)