Helpstats and Statistics Wizard

Tools
Enthusiast

Helpstats and Statistics Wizard

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?
1 REPLY
Enthusiast

Re: Helpstats and Statistics Wizard

Hi,

Not sure how to use statistics wizard... Can u help me pls!!!

Thanks,
abc