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 … Continue reading How to turn off/on bitmap indexes in SSAS
Category: BI
Thanks to everyone who came to the Dublin SQL UG last night! here's a link for the slides from the session https://skydrive.live.com/redir?page=view&resid=A24CC88336E6B2AB!16565&authkey=!AGqooaaRdMJe0qo Best Regards, Bob