
54
3.1
The Basics of Indexing
Note:
Excessive alternate indexing can lead to poor performance, most
especially in data warehouses. Often excessive alternate indexing indicates
data model problems or simply a mismatch between data model and appli-
cation requirements.
In short, alternate indexing is not a good thing, especially in data ware-
houses, for a number of reasons:
The very existence of alternate indexes in a data warehouse dimen-
sional-fact entity structure contradicts the very simplicity of that data
warehouse entity structure.
A dimensional-fact structure is much closer to the structure of actual
business processes than a regular ...