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