Dimensional Model Recomendations

Database
N/A

Dimensional Model Recomendations

Hi all,

We are developping dimensional model(snowflake) on teradata. I will aprreciate if those experienced on Teradata DM share their experience and recommendations. Recommendations specific to Teradata DMBS are appreciated rather than general DM concepts. i.e. on which columns we should collect statistics.(primary indexes, foreign keys??), which index works better ? SI on foreign keys or JI ?

Thanks
1 REPLY
Enthusiast

Re: Dimensional Model Recomendations

Regarding Collect Stats please refer to these recent discussions:

http://forums.teradata.com/forum/database/collect-stats-how-performance-gets-improved
http://forums.teradata.com/forum/database/diagnostic-commands-in-teradata

NUSI, at first blush, would be the better candidate for foreign keys if the index proves beneficial for query plans accessing these columns.