sql server data warehouse: Hi

I have a fact table with 23 columns on which I need to
build an index. For design purposes, I need to have a
composite key on
all the fact table columns but SQL Server 2000 has a
limitation of 16 indexes. How do we resolve this?

Thanks,

Venkatesh

The approach I have used is to create a surrogate key on the fact table (a
sequence of some sort). This allows a narrow unique clustered index which
helps performance in many cases with a star schema.


--
Kevin Connell, MCDBA
--------------------------------------------------
The views expressed here are my own
and not of my employer.
----------------------------------------------------
[quoted text, click to view]