We are currently deploying a new user interface and navigational structure on our Community. These design changes align with our new Teradata Access portal and provide a more cohesive experience for our users.
I have a couple of tables that are very wide. I am thinking about breaking them up into a star-schema-ish configuration (ETL, grouping, etc). For some of our legacy apps, I would need a view that re-creates the very wide table. My question is, would a multi-table join on primary indexes be as fast as the single, wide table? The data is these tables is very compressible (lots of Y/N indicators).