My warehouse data is split across 3 databases on the same server. While pulling into a cube, I am essentially doing this:
EDIT: Changed to UNION ALL based on suggestions
SELECT * FROM DB1.dbo.Fact_Pres UNION ALL SELECT * FROM DB2.dbo.Fact_Pres UNION ALL SELECT * FROM DB3.dbo.Fact_Pres
Should I actually consolidate the data into ONE table? Will that make my processing any faster?