You cannot define unique secondary indexes on a join index.
You can define the primary index of a join index to be row partitioned if and only if the join index is not also defined with row compression. For more information about specifying partitioned primary indexes for join indexes, see index (CREATE JOIN INDEX) .