diff options
| author | Shawn O. Pearce <sop@google.com> | 2009-01-13 07:55:32 -0800 |
|---|---|---|
| committer | Shawn O. Pearce <sop@google.com> | 2009-01-13 07:55:32 -0800 |
| commit | 89465658f2d0b13a9654be1c7e8661ef0d8b6878 (patch) | |
| tree | 334be5284becee40074fa1c8eabcad9ba1acaa15 | |
| parent | 087e8e71d6df3aac0134e2daedcc295c2a4a2643 (diff) | |
Add a missing index for the ChangeAccess.submitted query
Signed-off-by: Shawn O. Pearce <sop@google.com>
| -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 |