Posted by Erland Sommarskog on 10/26/07 21:12

DBMonitor (spamawayau@yahoo.com.au) writes:
> The query plans are as follows:
>
> -----------------
> Subquery Query (Total cost 41.52%)
> SELECT (0%)<-CS (0%)<-HM IJ (68%)<-IS Col1 (11%)
> .................................<-IS Col2 (20%)
>
> Standard Query (Total Cost 58.48%)
> SELECT (0%)<-CS (0%)<-HM IJ (78%)<-IS Col1 (8%)
> .................................<-IS Col2 (14%)
>
> KEY:
> CS - Comput Scalar
> HM IJ - Hash Match/Inner Join
> IS - Index Seek
>

I will have to confess that I hoped to see the full plans. Oh well.
Your choice.

> When I run it on a dedicated server, the times to run the queries are
> almost identical and the lastwaittypes change to CXPACKET and uses
> multiple threads.

What happens if you add OPTION (MAXDOP 1) to force a non-parallel plan?



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]