Topic
  • 1 reply
  • Latest Post - ‏2012-10-23T15:46:22Z by nivanov1
bella1
bella1
8 Posts

Pinned topic distribution clause db2

‏2012-10-23T05:42:03Z |
Hi,

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.
Updated on 2012-10-23T15:46:22Z at 2012-10-23T15:46:22Z by nivanov1
  • nivanov1
    nivanov1
    231 Posts

    Re: distribution clause db2

    ‏2012-10-23T15:46:22Z  
    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.