Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSAS INDEX Expand / Collapse
Posted Thursday, December 19, 2013 10:41 PM


Group: General Forum Members
Last Login: Thursday, December 19, 2013 10:40 PM
Points: 116, Visits: 395

What is Index in SSAS Cube? Are these index degrade the cube processing ? How these index work in cube ?



Post #1524860
Posted Tuesday, December 31, 2013 4:36 AM


Group: General Forum Members
Last Login: Yesterday @ 9:38 AM
Points: 1,887, Visits: 1,177
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 on Aggregation Design and what you can do to enable the Design Wizard to produce better aggregations.
Post #1526720
Posted Friday, January 10, 2014 11:34 AM


Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
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.
Post #1529916
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse