Skip to main content

New answers tagged

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 ...
Paul White's user avatar
  • 90.3k

Top 50 recent answers are included