All geek questions in one place

Internetworking

My warehouse data warehouse data is divided into 3 databases on one server. This is a Proof-Of-Concept project with three excerpts that have been uploaded to separate databases.

By immersing the cube, I basically do this:

SELECT * FROM DB1.dbo.Fact_Pres
UNION
SELECT * FROM DB2.dbo.Fact_Pres
UNION
SELECT * FROM DB3.dbo.Fact_Pres

Should I actually consolidate the data in ONE table? Will this speed up my processing?

I have no problems with disk space - I want to implement a better solution.

In any case, can you help me understand why the method you suggest will be optimal?

+3
source share
4 answers

- () , . , . , , .

ETL, ETL - , ETL - . .

Microsoft Project Real.

, .

+2

, . . , .

:

, , .

, , UNION ? UNION . , , UNION ALL?

+3

SQL Server ( , ). , , , , .

? , RAIDed . , .

, - , . , OP, , .

+3

A UNION select distinct, . () . , UNION ALL.

, , , . , SQL Server , , , . , UNION , , .

+1

Source: https://habr.com/ru/post/1724379/

More articles:


All Articles