What would be the easiest way to compare an Actual Execution Plan with an Estimated Execution Plan?
I can of course call "Visualize Plan" twice, once for Prepare and once for Execute but this is quite combersome.
In the end I need to compare the estimated number of rows to the actual number of rows to see where the optimizer fails to deliver appropriate estimates.
Next step would be to create/update statistics for the involved tables/columns.
How would I create a statistic which works on a simple predicate like "[ProductID] = 1" and ensures the correct estimate is provided to the query optimizer?
thanks in advance,