SQLite Forum

index question
Login
found the answer:

https://stackoverflow.com/questions/19357490/does-an-unique-constraint-remove-the-need-for-an-explicit-index-in-sqlite

which refers to: 
https://sqlite.org/lang_createtable.html#uniqueconst

which explains...