Question: what is difference between primary key and index?
Answer: A primary key has a unique constraint attached to it - so it also has an index. A database table has one clustered index (primary), the key being the primary key - if this exists - or a computed key, and more indexes on other columns.