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 ?