From 89465658f2d0b13a9654be1c7e8661ef0d8b6878 Mon Sep 17 00:00:00 2001 From: "Shawn O. Pearce" Date: Tue, 13 Jan 2009 07:55:32 -0800 Subject: Add a missing index for the ChangeAccess.submitted query Signed-off-by: Shawn O. Pearce --- appdist/src/main/sql/query_index.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/appdist/src/main/sql/query_index.sql b/appdist/src/main/sql/query_index.sql index 9aa122d983..aa741c8e71 100644 --- a/appdist/src/main/sql/query_index.sql +++ b/appdist/src/main/sql/query_index.sql @@ -78,6 +78,10 @@ ON account_group_members (group_id); CREATE INDEX changes_byOwnerStatus ON changes (owner_account_id, open, last_updated_on DESC); +-- covers: submitted +CREATE INDEX changes_submitted +ON changes (dest_project_name, dest_branch_name, status, last_updated_on); + -- ********************************************************************* -- ChangeApprovalAccess -- cgit v1.2.3