SSAS Tip - IndexBuildThreashold


<IndexBuildThreshold>

Index creation is controlled by the number of rows, specified in the msmdsrv.ini (default location of msmdsrv.ini file – ?:\Program Files\Microsoft SQL Server\MSAS10_50.SQL2008R2\OLAP\Config\msmdsrv.ini) file as <IndexBuildThreshold>, with a default of 4096. Partitions with fewer rows will not have indexes built.

Which means if you have less than 4096 records in a Partition you will not see Index for same.

How to Determine Index is present or not –

SELECT * FROM SYSTEMRESTRICTSCHEMA(
$SYSTEM.DISCOVER_PARTITION_DIMENSION_STAT
, CUBE_NAME = 'Adventure Works'
, DATABASE_NAME = 'Adventure Works DW 2008'
,MEASURE_GROUP_NAME = 'Internet Sales'
,PARTITION_NAME = 'Internet_Sales_2004')

 

image

Look for Attribute Index Col.

Comments (1)

  1. Rakesh Jayaram says:

    You can also set the slice property for the partition

Skip to main content