When a process definition filter is used and the authorization check is active, then the process definition table is joined twice. This can be consolidate into one join.

—

Which join type to use (left join, inner join)?

• If cmmn and standalone tasks are disabled,
  • inner join (since every remaining task must belong to a process definition)
• Else
  • If it is an or query
    • left join
  • If it is an and query
    • If authorization is enabled
      • left join (to not lose cmmn tasks for which we do not enforce permissions)
    • If authorization is disabled
      • inner join