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

Indexing Fact and Dimension Tables Expand / Collapse
Author
Message
Posted Monday, November 12, 2012 2:14 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, April 12, 2013 12:23 PM
Points: 606, Visits: 587
Is there a way to create index on fact and dimension tables in cube?
Post #1383870
Posted Tuesday, November 13, 2012 1:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:15 AM
Points: 13,017, Visits: 10,800
No. A cube uses a different storage engine than the relation model.
Furthermore, an index is used to find the needle in the haystack. A cube is used to aggregate the haystack Using indexes in cubes would be against what the cube is really for.

If it is to speed up aggregations calculations, you can design aggregations in your cube.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1383971
Posted Tuesday, November 13, 2012 11:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 12:40 PM
Points: 47, Visits: 236
yeah.. indexing is basically all automated.. you don't create index per se.... because cube is really for aggregated results.. not to find a single entry (like relational index)

to speed up query .. you go with aggregations..

with aggregations.. you first go through the wizard.. then you use query log to perform "usage based optimization".. then you design your own..

I usually just do usage based optimization as it's easy and to the point.
Post #1384218
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse