There's no concept of a secondary index. An index is an index. Some are unique indexes, which force each value to be unique, some are not. Primary Key is essen

There's no concept of a secondary index. An index is an index. Some are unique indexes, which force each value to be unique, some are not. Primary Key is essentially syntactic sugar for not null and a unique index.