Forum Discussion
Index column for dimension table?
Hi ModelFear -Using an index column for a dimension table is generally a best practice if we check the good example that i came across:
1. Unique identifier for each row in a table when you referenced with fact table relationship
2.Good for performance optimization for identifying the distinct record in your dimension table.Indexes are typically faster to join on because they require less memory and processing power.
3. Index columns help to avoid issues related to null or duplicate values in natural keys (like names or dates). An index is always unique and not null.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Hi ModelFear -Using an index column for a dimension table is generally a best practice if we check the good example that i came across:
1. Unique identifier for each row in a table when you referenced with fact table relationship
2.Good for performance optimization for identifying the distinct record in your dimension table.Indexes are typically faster to join on because they require less memory and processing power.
3. Index columns help to avoid issues related to null or duplicate values in natural keys (like names or dates). An index is always unique and not null.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Hi rajendraongole1
Thank you! I will follow this neat 1 min video to hide the index column after creating it.
https://www.youtube.com/watch?v=dN3QYYbdk9c&t=1s