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
Author
Message
Posted Thursday, December 19, 2013 10:41 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 11:26 PM
Points: 116, Visits: 397
Hello,

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



Regards,

Sanjeewan


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

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:35 AM
Points: 2,123, Visits: 1,451
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
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