What kinds of histograms are there?
Value-based histograms (FREQUENCY histograms) If there are fewer different values in the column than the amount of buckets used, each bucket contains one column value and the frequency of this column value. Height-balanced histograms (HEIGHT BALANCED histograms) If there are more different values in the column than the amount of buckets used, the column values are divided into intervals of the same size. In this case, an interval is assigned to each bucket.