What is the best way to index a Netezza fact table with lots of primary keys. For now, let's suppose we have 10 primary keys. This table is mainly used to store meta data about our database.
6/21/2012 - update
This is the diagram for SQL Server or Oracle, not Netezza. I haven't built this table on Netezza yet. Some of the primary keys you see in the fact table are also foreign keys (concept_cd, provider_id, encounter_num are 3 example FKs).