AXISHK
asked on
Cluster key on Dimension table
I have a surrogate key (auto-increment) in the dimension table and there are some other fields (not business key) that will be used for report query. Should I need to create a clustered index to include these keys ? Or the clustered index should only include business key of Fact tables and I should create a separate index to include those columns that will only used for report query and pivot columns ?
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER