Create Index on Partitioned Table

Index must be aligned on Partitioned Tables, In order to create index on Partitioned Table, DBA needs to identify, whether he want to create an index which will unique or it will allow duplicates,

Unique Index:

If the required Index is Unique then partitioning column must be part of index key columns

Duplicate is ok:

If the required Index is with duplicate ok, then no need to include the partitioning column in index key columns, Just specify columns and create index based on Partitioning Scheme