can you please help on below. we have below query with “order by createDate desc”
without it below index work with order by it timeout and index is not scanned properly.
stateSpecId)) WHERE (
type = “processinstance”)
QUERY: “order by createDate desc” without order by works with order by timeout.
SELECT * FROM
optima WHERE type = ‘processinstance’ and relatesToDomain == 1 and currentState.stateSpecId != 2000 order by createDate desc LIMIT 24 OFFSET 0