diff options
Diffstat (limited to 'appdist/src/main/sql/query_index.sql')
-rw-r--r-- | appdist/src/main/sql/query_index.sql | 4 |
1 files changed, 4 insertions, 0 deletions
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 |