Histograms give the optimizer a more detailed view of the distribution of data values in the column. DBMS_STATS package can be used to create a histogram.

For table columns that contain values with large variations in number of duplicates, called skewed data.