I'm work in data warehouse solutions. Can you talk about indexes in DW? Generally, I create index using the most commons FK's joins e use include option with the most commom measures in non clustered indexes. Is it a good pratice? Thank you!
Generally speaking I would: - Create clustered indexes on PK columns - Create Non-Clustered indexes on other columns that are commonly used in JOINs or WHERE clauses