Ben Chuanlong Du's Blog

It is never too late to learn.

Primary Key vs Index in SQL

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

  1. index is for distribution data index does not have to be unique

  2. primary key must be unique and non null

  3. primary keys are automatically indexed

Comments