--create index IndexBuildsOnJob on Builds(project, jobset, job);
--create index IndexBuildsOnJobAndIsCurrent on Builds(project, jobset, job, isCurrent);
create index IndexBuildsOnJobAndSystem on Builds(project, jobset, job, system);

create index IndexBuildsOnJobsetFinishedTimestamp on Builds(project, jobset, finished, timestamp DESC); -- obsolete?

create index IndexBuildsOnJobSystemCurrent on Builds(project, jobset, job, system, isCurrent);

create index IndexMostRecentSuccessfulBuilds on Builds(project, jobset, job, system, finished, buildStatus, id desc);

drop index IndexBuildsOnJobAndSystem;
drop index IndexBuildsOnJobSystemCurrent;
drop index IndexBuildsOnJobsetFinishedTimestamp;
drop index IndexMostRecentSuccessfulBuilds;