Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance - union
Message
From
03/02/2012 06:48:37
Fabio Lunardon
Lunacom
Marostica, Italy
 
 
To
02/02/2012 20:38:14
John Jones
Kuala Lumpur, Malaysia
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Performance - union
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01534182
Message ID:
01534385
Views:
45
>Hi
>You can refer to this link
>
>http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/7e5e08d0-2ef3-4858-b4cf-c73541edc178
>
>Thank you


The issue is Table Spool step.

define view with UNION ALL
and try
query syntax OPTION (FORCE ORDER)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform