Your primary key is there to uniquely identify a record. You need additional indexes on fields you will search on.