Timeline for Can the table spool operator be parallelised?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 12, 2018 at 12:48 | history | edited | Aaron Bertrand | CC BY-SA 4.0 |
sqlblog.com died
|
| Apr 23, 2012 at 21:08 | comment | added | user8369 | technically you may be correct that it could work reading in parallel however I know that, even in sequential plans spools can only be read from one at a time (i.e. if there are 5 occurrences of a spool being used in a plan they have to be done in one at a time and cannot be read in parallel). I'll be honest, whilst I know query plans quite well I'm not a massive expert on parallelism but I'm sure that spools are one of the operators that break parallelism. Have a look at Adams stuff I linked earlier for more info | |
| Apr 23, 2012 at 17:08 | comment | added | thecoop | The reads can't happen in parallel, even though the temp table is written to once and then only read from? | |
| Apr 23, 2012 at 16:23 | history | answered | Dave Morrison | CC BY-SA 3.0 |