Is it possible to speed up the processing of a dimension made on the basis of a fact table?

Question

SQL

There is a fact table containing about 140 million rows. It is divided into 8 parts and processed in a total of 12 minutes.
There is a dimension that is built on the basis of the fact table (a view based on the fact table for building filters in the report), it is processed for 2 hours and 30 minutes. Is there any way to speed up the processing of the measurement?

Answer 1

140 million records is not much. So:
1. Analyze the query plan: https://technet.microsoft.com/en-us/library/ms1780... .
2. Optimize the query (perhaps split it into several independent queries with intermediate results stored in temporary tables).
3. Create the indexes necessary for this query.
4. Set up the DBMS parameters.
And as a more radical option, use a specialized DBMS optimized for OLAP.