Hi,
There is a long query like this:
SELECT Col1, Col2,..., Coln FROM Database1.DBO.Table WHERE ...
UNION
SELECT Col1, Col2,..., Coln FROM Database2.DBO.Table WHERE ...
UNION
SELECT Col1, Col2,..., Coln FROM Database3.DBO.Table WHERE ...
UNION
SELECT Col1, Col2,..., Coln FROM Database4.DBO.Table WHERE ...
.......
The query will go to almost 50 databases and UNION the results into a single table. It seems that the query searches each database one by one. From a given situation like this is there anyway to speed up the query? Can I tell it to run in parallel? How?
Thanks a lot.