December 19, 2013 at 10:41 pm
Hello,
What is Index in SSAS Cube? Are these index degrade the cube processing ? How these index work in cube ?
Regards,
Sanjeewan
--------------------------------------------------------------------------------
December 31, 2013 at 4:36 am
The equivalent of indexes in an OLAP Cube are Aggregations. Far from degrading performance, correctly-designed Aggregations can improve performance tremendously (be careful not to have too many though).
Chris Webb has an excellent blog post here[/url] on Aggregation Design and what you can do to enable the Design Wizard to produce better aggregations.
January 10, 2014 at 11:34 am
There are also other internal bitmap indexes in the various file structures containing dimension data, but these are not indexes that you typically create declaratively with DDL like in an RDBMS. For example, the two level bitmap indexes in SSAS consist of a block index and a page level index.
These indexes are what gives SSAS such great read speed.
The physical internals of SSAS is a subject in and of itself.:-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply