Search
InstantDoc ID
GO

Browse By: Author | Issue

July 30, 2008 02:30 PM

Indexing the Data Warehouse

Check out how to index dimensions and fact tables for optimum performance
Rating: (0)
Michelle A. Poolet
SQL Server Magazine
InstantDoc ID #99330
Executive Summary: Indexing the data warehouse can reduce the amount of time it takes to see query results. When indexing dimensions, you'll want to index on the dimension key. When indexing the fact table, you'll want to index on the date key or the combined data plus time.
...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Wonderful article. Keep writting Michelle.

Marcos8/6/2008 2:23:07 PM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

The Essential Guide to SQL Server 2005 BI
A Essential Guides by Dell
Moving SQL Server to the x64 Platform
A EBooks by AMD
Top 8 Considerations for Sizing a Microsoft SQL Server BI Solution
A Tip Guides by Hewlett-Packard
A Jump Start to SQL Server BI
A EBooks by Microsoft
More
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.