Hi,

I seek advice on how to index the fact table.

1. Clustered Index on combination of all dimension keys.

The problem is how do I pick this combination.

2. Have a PK col (Identity) and cluster index that. All FK's to be non-clustered.

I don't think I am having a good handle at indexing the fact tables. Please let me know your suggestions.

Thanks,

Vivek