histograms
Table of Contents
Histograms
Top Frequency Histograms
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.
The less popular values are considered insignificant.
Less popular values are therefore grouped together in a single bucket.
Hybrid Histograms
As the name suggests, a combination of Height Balanced and Frequency histograms.
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.
histograms.txt · Last modified: 2021/12/06 11:30 by 127.0.0.1