clustered index or simple constraint in a fact table?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jéjé (willgart_at__A_hotAmail_A_.com)
Date: 02/28/04 

Date: Sat, 28 Feb 2004 15:07:18 -0500

Hi,

What do you recommand to insure the integrity of a fact table?
a cluster index?
or a constraint?
or an SQL script?

do you recommand to allways having a clustering index on a fact table? or
just on the dimension tables and 1 index by linked column in the fact table?

I don't want to test each possibility, so I want your help ;)

Jerome. 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.600 / Virus Database: 381 - Release Date: 2004-02-28