2015-12-12 22:13 GMT+01:00 Richard Hipp :
> On 12/12/15, Cecil Westerhof 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
I have the following tables:
CREATE TABLE "projects" (
"projectID" TEXT PRIMARY KEY,
"groupID" TEXT,
"isPersonal"INTEGER NOT NULL CHECK(ispersonal in (0, 1)),
"name" TEXT,
"description" TEXT,
"outcome" TEXT
);
CREATE INDEX projects_groupID_idx
On 12/12/15, Cecil Westerhof 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
3 matches
Mail list logo