Indexing Fact and Dimension Tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Indexing Fact and Dimension Tables

Indexing Fact and Dimension Tables

Rate Topic

Display Mode

Topic Options

Author

Message

sqlizer

Posted Monday, November 12, 2012 2:14 PM

SSChasing 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

Koen Verbeeck

Posted Tuesday, November 13, 2012 1:29 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:14 PM
Points: 9,370, Visits: 6,468

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 Smile

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

boxta

Posted Tuesday, November 13, 2012 11:34 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 04, 2013 7:00 PM
Points: 43, Visits: 219

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 »

Permissions