groundwalker.com

SQLite creates an index for every UNIQUE column automatically.

SQLite は UNIQUEなコラムに自動でインデックスを作るよ。

For example, you give a schema like the following,

create table memos (
 mtime timestamp unique not null,
 content text not null
);

Then, you can recognize autoindex for mtime.

sqlite> select * from sqlite_master;
.....
index|(memos autoindex 1)|memos|3|