2015-12-12 22:13 GMT+01:00 Richard Hipp <drh at sqlite.org>: > 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. >
?Stupid error. :'-( Should be: ?CREATE INDEX subprojects_projectID_idx ON subprojects(projectID);? -- Cecil Westerhof