It depends. The PK create an index, if you have specific where criteria which makes use of the compsite primary key you are creating, try to create PK column order such a way it benifits your queries.