This is a two part question:
First, is the primary reason DTA suggests new statistics because it generates multi-column stats whereas autoupdate stats only computes single-column ones? Or is that because the current statistics are out of date (i.e. if you ran sp_updatestats first,
would DTA then not need to recommend any?)
Second, is it fair to say that if you have a multi-column index, you should manually create a multi-column statistic to go along with it?
View Complete Post