You can’t have 2 primary keys, the primary key is also the way the data is physically ordered, so a table couldn’t be ordered multiple ways, indexes are so that you can order the table quickly multiple ways, but the primary key is the actual way the table is stored.