SELECT COUNT(*)
FROM BranchMergeProposal join branch as source on source.id=branchmergeproposal.source_branch and source.product=7432 join branch as target on target.id=branchmergeproposal.target_branch
WHERE source.private = false or source.id in( (SELECT Branch.id FROM Branch, TeamParticipation WHERE Branch.OWNER = TeamParticipation.team AND TeamParticipation.person = 790463 AND Branch.private = TRUE) UNION (SELECT Branch.id FROM Branch, BranchSubscription, TeamParticipation WHERE BranchSubscription.branch = Branch.id AND BranchSubscription.person = TeamParticipation.team AND TeamParticipation.person = 790463 AND Branch.private = TRUE))
AND target.private=false or target.id IN( (SELECT Branch.id FROM Branch, TeamParticipation WHERE Branch.OWNER = TeamParticipation.team AND TeamParticipation.person = 790463 AND Branch.private = TRUE) UNION (SELECT Branch.id FROM Branch, BranchSubscription, TeamParticipation WHERE BranchSubscription.branch = Branch.id AND BranchSubscription.person = TeamParticipation.team AND TeamParticipation.person = 790463 AND Branch.private = TRUE))
AND BranchMergeProposal.queue_status IN (3, 2)
looks like a significant improvement on the branch merge proposal queries - 39 and 40 in OOPS-1906G1635 - which btw are identical, so another source of potential improvement.
SELECT COUNT(*) id=branchmergep roposal. source_ branch and source.product=7432 join branch as target on target. id=branchmergep roposal. target_ branch
(SELECT Branch.id
FROM Branch,
TeamParticipa tion
WHERE Branch.OWNER = TeamParticipati on.team
AND TeamParticipati on.person = 790463
AND Branch.private = TRUE)
UNION
(SELECT Branch.id
FROM Branch,
BranchSubscri ption,
TeamParticipa tion
WHERE BranchSubscript ion.branch = Branch.id
AND BranchSubscript ion.person = TeamParticipati on.team
AND TeamParticipati on.person = 790463
AND Branch.private = TRUE)) private= false or target.id IN(
(SELECT Branch.id
FROM Branch,
TeamPartici pation
WHERE Branch.OWNER = TeamParticipati on.team
AND TeamParticipati on.person = 790463
AND Branch.private = TRUE)
UNION
(SELECT Branch.id
FROM Branch,
BranchSubsc ription,
TeamPartici pation
WHERE BranchSubscript ion.branch = Branch.id
AND BranchSubscript ion.person = TeamParticipati on.team
AND TeamParticipati on.person = 790463
AND Branch.private = TRUE)) osal.queue_ status IN (3,
2)
FROM BranchMergeProposal join branch as source on source.
WHERE source.private = false or source.id in(
AND target.
AND BranchMergeProp
looks like a significant improvement on the branch merge proposal queries - 39 and 40 in OOPS-1906G1635 - which btw are identical, so another source of potential improvement.