On 12/12/15, Cecil Westerhof <cldwesterhof at gmail.com> wrote: > I have the following tables: > CREATE TABLE "projects" ( > "projectID" TEXT PRIMARY KEY, > ); > CREATE INDEX subprojects_projectID_idx > ON projects(projectID);
Don't create indexes on primary keys. Doing so still gives a correct answer, but it wastes space and CPU cycles. -- D. Richard Hipp drh at sqlite.org
