In my AEM DAM when "asset expiry notification" Job run. it throws below exception every time.
The query read or traversed more than 100000 nodes. To avoid affecting other tasks, processing was stopped
1) OAK indexes are already in place for the Query
2) I also checked that number of dam: asset nodes are not more than 25000