Hi,

what the differents option available in the DataCompressionSettings
registry entry do?

specially these 2 options : MAP_NOT_USE_INDEX & MAP_NOT_BUILD_INDEX

(http://msdn.microsoft.com/library/de...egsettings.asp)

I have a lot of dynamic distinct count measures in my cubes, does this type
of indexes changes anything ?

what is the impact from a storage & performanc point of view?

there is a remark in the web site:
Remarks
Analysis Services can use either the bitmap or traditional index to optimize
query response. Although the bitmap index generally performs better than the
traditional index, there are some circumstances in which the traditional
index performs better than the bitmap index. If you decide to use
traditional indexes, keep in mind that they are slower to create than binary
indexes.

what are the circumstances when traditional index performs better than the
bitmap index?


thanks.

Jerome.