Hi,

My current DB is not using the SQL2k native feature
to maintain my table relationship.

We need to build a impact analysis tool
to know any modification to our application value,
we will know the 'impact' to other table and to
valid whether user are able to proceed.

Hence, we need to build a fact table which is
a denormalize table from our normalize tables. This is
give us the relations between tables in a denormalize
form. So, our fact table are huge in size.

Do anyone know how to optimize this
denomalize table in order to achieve
the same objective of having a fact
table that is small in size.