on 03-08-2017 2:46 PM
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,
-gerhard
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.