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-6ae26cb51efaf660888672/]