* What to do with the primary key?

  Most of the discussions here apply to primary key as well.
  
  In othere words, should the primary key be created as
  nonpartitioned index or
  Global prefixed index or
  Local prefixed index or
  Local non-prefixed index
  ?
  
  Same rules of choosing a particular index type apply here also.
  Basically the question "should the partitioning key be the same as the primary key" or
                         "should the partitioning key be a subset of the primary key columns"
  is no different from asking "what type of indexes should be created". The guidelines of choosing
  one of the above mentioned index types should be followed.
  
  One more caviar to the issue is, what if the primary key is a meaningless surrogate key, as is
  the case with most of the tables in a data warehouse? Look here for discussions on this issue.