var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Indexing Fact tables
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.