Gathering Stats with SIZE AUTO

Pros

Works for most cases. Job is automatically created and scheduled when database is created.

Cons

  • Not always clear when histograms will be used.
  • Column usage can affect stats gathering, ie difference between Production load and Test load on the same datasets
  • See Hermant's article on Column Usage affecting histograms here, here, and here.