Clustered Columnstore Index in Azure SQL Database | Microsoft...
the FACT table is the one with most rows and it has large number of columns. With columnstore storage, SQL Server needs to fetch only the referenced columns unlike rowstore where the full row needs to be fetched