I am playing with SQLite. I am thinking about writing an application for projects. At the moment I have the following:
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 projects(groupID); CREATE INDEX projects_isPersonal_idx ON projects(isPersonal); ?I like to differentiate between personal and non personal projects. Is it a good idea to put a index on isPersonal? By the way: I am thinking about using UUID for projectID and groupID, but I heard somewhere that it was a bad idea to use UUID for an indexed field. Is this true?? -- Cecil Westerhof