can any tell me the significance of distribution clause in runstats in simple language?
I am not able to understand which scenario's it shall be used.
This topic has been locked.
Pinned topic distribution clause db2
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
nivanov1 100000H9H7231 Posts
Re: distribution clause db22012-10-23T15:46:22ZThis is the accepted answer. This is the accepted answer.You probably want to use the distribution statistics when the distribution of index key values is not uniform. For example, if you have a column with persons' birth dates, the distribution of the dates will be more or less uniform. However, if the column stores the dates when people take their vacations, you will have higher frequency of values during the summer months and around major holidays.