Why You Don’t Get Parallelism When You Ask for The Whole Table
Let's say you're working with a big copy of the Stack Overflow database, and you wanna get all the users, like for a data export. SQL Server doesn't parallelize this query, not even if you use the query hint that asks for a parallel plan:
[crayon-6ae25d3c36d09061753229/]