[CAM-12073] Improve Task Query Performance in PostgreSQL - camunda JIRA

Given:
A large PostgreSQL Task data set;

When:
Tasks are obtained for some given filter criteria.

Then:
The Task query is slow and inefficient because of the expensive sort operation caused by the DISTINCT statement.

Expected:
The Task Query is optimized by using the PostgreSQL DISTINCT ON statement when default ordering is used (by Task ID).

Given:
A large PostgreSQL Task data set;

When:
Tasks are obtained for some given filter criteria.

Then:
The Task query is slow and inefficient because of the expensive sort operation caused by the DISTINCT statement.

Expected:
The Task Query is optimized by using the PostgreSQL DISTINCT ON statement when default ordering is used (by Task ID).

is related to

CAM-11277 Improve Task Query Performance

camunda BPM