I have requirement to gather statistics recommendations for a certain query. I have used diagnostic "helpstats" and Statistics wizards to gather the recommendations.My assumption was that Helpstats and Stats Wizard would both recommend same number of recommendations.However, i was wrong in assuming so. I see that Helpstats makes more number of recommendation for the same query ,ofcourse with (High Conf). Why did this happen? Is it usual to see the difference.
Now my question is Which is the Best approach to gather recommendations on Statistics Collections, Helpstats or Statistics Wizard?