Use the histogram tuning factor configuration parameter to determine a histogram’s distribution granularity (that is, the step count) for the server.
The update statistics ... histogram_tuning_factor parameter determines update statistics’ distribution granularity for histograms, which helps to isolate skew values and improves equi-weight range cell behavior. update statistics transforms the final histogram to conform to the configured step count for range cells, but retains any frequency cells. If the final histogram update statistics produces appears to skew the weights, try increasing the tuning factor to create more equi-weight range cells.
