New answers tagged parallelism
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 ...
Top 50 recent answers are included
Related Tags
parallelism × 211sql-server × 113
performance × 44
postgresql × 41
query-performance × 23
oracle × 21
execution-plan × 20
sql-server-2016 × 16
mysql × 14
sql-server-2014 × 13
performance-tuning × 12
deadlock × 12
maxdop × 12
optimization × 10
postgresql-performance × 10
oracle-12c × 9
functions × 9
sql-server-2008 × 7
sql-server-2008-r2 × 7
sql-server-2017 × 7
stored-procedures × 6
sql-server-2019 × 6
sql-server-2012 × 4
t-sql × 4
amazon-rds × 4