User Tools

Site Tools


histograms

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.

Oracle Base Article

histograms.txt · Last modified: 2021/12/06 11:30 by 127.0.0.1