Indexing the Data Warehouse

Friday Aug 1st 2008 by DatabaseJournal.com Staff

Check out how to index dimensions and fact tables for optimum performance.

[From SQL Server Magazine]

Indexing a data warehouse is tricky. If you have too few indexes, the data loads quickly but the query response is slow. If you have too many indexes, the data loads slowly and your storage requirements go through the roof but the query response is good. Indexing in any database, transactional or warehouse, most often reduces the length of time it takes to see query results. This is especially true with large tables and complex queries that involve table joins.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=99330

Mobile Site | Full Site