Search code examples
sql-serverssasssas-2008ssas-2012

Partition and Filter Queries in Tabular model SSAS


I am very new to Tabular model.How does creating the partion (to a once of the transaction data table)and applying filter queries to each partition beniftd the Query performance?


Solution

  • Refer the following link http://msdn.microsoft.com/en-us/library/hh230810.aspx

    FYI: Partitions improve query performance by narrowing the amount of data supposed to be scanned to get the result.