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
Want to build a reliable, modern data architecture without the mess?
Here’s a free checklist to help you → bit.ly/kds-checklist
Great explanation, thanks.
I'm moving from an analyst position to the data engineering side, and your videos have been very helpful.
Great to hear! And congrats on making the move to engineering
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
Great video! The impact would have been greater if a demo was shown in addition to the explanation.
Thanks! And yes I agree - I'll have to do another video with a more specific demo.
Thank you Kahan
You’re welcome - thanks for watching!
Thank you, not abundant, clear and precise explanation.