10
votes
Accepted
Why is the tipping point between a serial and parallel plan not exactly the point where the serial plan is costed less?
The tipping point is as you expect. The showplan information doesn't accurately reflect optimizer costing.
The first two queries (parallel natural and serial hinted) both have a cost of 62.6855 at ...
- 90.2k
3
votes
Accepted
Why I don't see the OptimizerStatsUsage in the execution plan
the stackoverflow2010 database might be set to lower version of compatibility level. During my test it is set to 100 which is 2008. You either need to change the database compatibility level to ...
- 491
2
votes
Why execution plan could be skipped from XE session?
It looks like you are using a ring buffer and "Watch Live Data".
Sometimes, plans can be larger than 4MB (the default setting for XE), and they can be dropped from the result set.
You should ...
- 21
Only top scored, non community-wiki answers of a minimum length are eligible