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

Pinned topic distribution clause db2

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

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.
  • nivanov1
    231 Posts

    Re: distribution clause db2

    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.