All Forums Database
guwen 1 post Joined 09/10
16 Sep 2010
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

robpaller 159 posts Joined 05/09
16 Sep 2010

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.

You must sign in to leave a comment.