Parallel Threads

From: Kenneth Naim <>
Date: Wed, 11 Mar 2009 09:35:03 -0400
Message-ID: <E4F7B5022505450C949A400CF85253DC_at_KenPC>

How can I tell how many parallel threads were spawned by a parallel query after the query completed. I have a query that normally takes a couple hours but ran for 24 hours over the weekend. My theory is that the 40 parallel threads were reduced by the optimizer for some reason so I'd like to know how many threads it used.  



Received on Wed Mar 11 2009 - 08:35:03 CDT

Original text of this message