parallelism

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Tue, 04 Sep 2001 05:33:18 -0700
Message-ID: <F001.003818CA.20010904053253@fatcity.com>

We were discussing when to set degree parallelism on a table. You experts out there, is there a number of rows that it makes sense to set it to something other than default? I know there are times when parallel can be slower than serial processing but what is that threshold. We are definitely setting it for the partitioned tables but wasnt sure if we should set it for other ones also.

thanks, joe

Received on Tue Sep 04 2001 - 07:33:18 CDT