Link to home
Start Free TrialLog in
Avatar of AXISHK
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

ASKER CERTIFIED SOLUTION
Avatar of TempDBA
TempDBA
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AXISHK
AXISHK

ASKER

Tks