Report Portal

How to turn off/on bitmap indexes in SSAS

Bitmap Indexes (*.map files) play an important role within Analysis Services. They provide a mechanism for the storage engine sub cube event to efficiently locate the relevant segments within the fact file without having to scan the whole thing. This is how you can have a 20 GB *.fact file in the partition but still get storage engine events of only 50ms or so.

Read more...

Tags: management, performance

 

2007-2015 VidasSoft Systems Inc.