I would like to know, when I'm creating a partition on a table, partition field should be part of primary key or unique key?
More specifically, I have table with existing 2 columns (example ColumnA, ColumnB) in the primary key. I would like create a partition on ColumnC. Is it necessary to add ColumnC as a part of primary key?
Any comments will be appreciated.