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.
1 reply Latest Post - 2012-10-23T15:46:22Z by nivanov1
Pinned topic distribution clause db2
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-23T15:46:22Z at 2012-10-23T15:46:22Z by nivanov1
nivanov1 100000H9H7231 PostsACCEPTED ANSWER
Re: distribution clause db22012-10-23T15:46:22Z in response to bella1You 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.