SQL Server Performance Forum – Threads Archive

From Spanish Forum

New member need to know if there is any way to force a query to use parallel processor. Box has 8 processor and he want to use in specific query. I said SQL choose the best execution plan to get best performance, and also said in some cases is better to reduce parallelism, etc, etc, etc.
Well, He insist it original question.
So, I’m not sure about how to force that.
Luis Martin
Moderator
SQL-Server-Performance.com

---

you can’t really force a query to use parallel processing, you can set "cost threshold for parallelism" to a number less than the default of 5 which will cause simpler queries to also consider parallel plans, but you can’t force them to do so Cheers
Twan

---

Thanks, that’s wath I think. Luis Martin
Moderator
SQL-Server-Performance.com

---

]]>