DAM asset expiry notification JOB || Query optimisation

Hi Experts,

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

===================================================================

I checked:

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

Thanks,

Suresh