Re: Parallel execution strategy

From: Frank van Bortel <>
Date: Tue, 18 Mar 2008 21:51:46 +0100
Message-ID: <d2766$47e02b62$524b5c40$> wrote:
> That was my main idea as well. But there is more to it than that. For
> instance (and certainly under specific circumstances I haven't tried
> to determined), a query with an inner join of a huge table and a tiny
> one won't be parallelized unless the degree of *both* tables is
> greater than 1.

I can confirm that (but don't ask the details - it's been 3 years since I last visited that customer); iirc, reversing the order of naming the tables did the trick in some cases; other needed hints. I understand that might be difficult to realize (since there are 'suppliers' - suspect you meant software suppliers?)


Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up
Received on Tue Mar 18 2008 - 15:51:46 CDT

Original text of this message