|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Parallel Plan - wrong results
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Parallel Plan - wrong results
|
|
|
| I'm using SqlServer 2000 (SP2) on Windows Advanced Server
2000 (SP2). The server has 8 processors and SqlServer is
configured to use all the processors to run parallelism.
I created a view based on the union of 3 selects.
A column of this view can contains two values: null or a
forein key from a real table.
If i make a select, joining the view and the referencing
table, using a parallel plan, i get only 11 rows.
If i make the same select, disabling the parallel plan, it
works fine (29400 rows).
Example
View:= SELECT ID, OBJECT, TYPE FROM DOC_TYPE1
UNION
SELECT ID, OBJECT, TYPE FROM DOC_TYPE2
UNION
SELECT ID, OBJECT, NULL AS TYPE FROM DOC_TYPE3
Table  OC_TYPES (TYPE_ID, TYPE, TYPE_DESCRIPTION)
Query : SELECT * FROM "view", DOC_TYPES
WHERE "view".TYPE= DOC_TYPES.TYPE
Someone can help me ?
Thanks
Paolo
| |
| Andrew J. Kelly 2002-11-28, 9:24 am |
| Please don't post independently in multiple newsgroups. See my reply in
..programming.
--
Andrew J. Kelly
SQL Server MVP
"Paolo" <fpaolo@tin.it> wrote in message
news:1ca3101c296e1$c1f98b40$8d
f82ecf@TK2MSFTNGXA02...
> I'm using SqlServer 2000 (SP2) on Windows Advanced Server
> 2000 (SP2). The server has 8 processors and SqlServer is
> configured to use all the processors to run parallelism.
> I created a view based on the union of 3 selects.
> A column of this view can contains two values: null or a
> forein key from a real table.
> If i make a select, joining the view and the referencing
> table, using a parallel plan, i get only 11 rows.
> If i make the same select, disabling the parallel plan, it
> works fine (29400 rows).
>
> Example
>
> View:= SELECT ID, OBJECT, TYPE FROM DOC_TYPE1
> UNION
> SELECT ID, OBJECT, TYPE FROM DOC_TYPE2
> UNION
> SELECT ID, OBJECT, NULL AS TYPE FROM DOC_TYPE3
>
> Table OC_TYPES (TYPE_ID, TYPE, TYPE_DESCRIPTION)
>
> Query : SELECT * FROM "view", DOC_TYPES
> WHERE "view".TYPE= DOC_TYPES.TYPE
>
> Someone can help me ?
>
> Thanks
> Paolo
>
>
|
|
|
|
|