Fact Database

The fact database is used as a key database for Source Systems that are connected through an Integration Adapter.

The integration adapter copies or exports the data to the Staging Database. In the staging database all necessary transformations are done and then the data is copied to the Fact Database. The fact database is the main source for the SSAS OLAP cube.

Remove indexes from fact database

Use the below SQL query to remove index from the fact database.

USE [DATABASE_NAME]

GO

if exists (select * from sys.indexes where [name] = 'INDEX_NAME')

DROP INDEX [INDEX_NAME] ON [dbo].[TABLE_NAME]

GO

Replace the placeholder text DATABASE_NAME, INDEX_NAME and TABLE_NAME with the corresponding values as applicable. Place holder texts are self-explanatory.