liquid_feedback_core
changeset 592:332a2177e208
Reduced indices on "issue" table
author | jbe |
---|---|
date | Sat Dec 08 01:26:25 2018 +0100 (2018-12-08) |
parents | d955519f7471 |
children | e7f772ca0621 |
files | core.sql |
line diff
1.1 --- a/core.sql Fri Dec 07 17:49:53 2018 +0100 1.2 +++ b/core.sql Sat Dec 08 01:26:25 2018 +0100 1.3 @@ -866,12 +866,8 @@ 1.4 ("fully_frozen" ISNULL OR "full_freeze_snapshot_id" NOTNULL) ) ); 1.5 CREATE INDEX "issue_state_idx" ON "issue" ("state"); 1.6 CREATE INDEX "issue_created_idx" ON "issue" ("created"); 1.7 -CREATE INDEX "issue_accepted_idx" ON "issue" ("accepted"); 1.8 -CREATE INDEX "issue_half_frozen_idx" ON "issue" ("half_frozen"); 1.9 -CREATE INDEX "issue_fully_frozen_idx" ON "issue" ("fully_frozen"); 1.10 CREATE INDEX "issue_closed_idx" ON "issue" ("closed"); 1.11 -CREATE INDEX "issue_created_idx_open" ON "issue" ("created") WHERE "closed" ISNULL; 1.12 -CREATE INDEX "issue_closed_idx_canceled" ON "issue" ("closed") WHERE "fully_frozen" ISNULL; 1.13 +CREATE INDEX "issue_open_created_idx" ON "issue" ("created") WHERE "closed" ISNULL; 1.14 CREATE INDEX "issue_latest_snapshot_id_idx" ON "issue" ("latest_snapshot_id"); 1.15 CREATE INDEX "issue_admission_snapshot_id_idx" ON "issue" ("admission_snapshot_id"); 1.16 CREATE INDEX "issue_half_freeze_snapshot_id_idx" ON "issue" ("half_freeze_snapshot_id");