When we had try to purge the workflow (completed/aborted), we got query limit exception issue, so we thought of fine tuning /oak:index/workFlowDataLucene with includedPaths / excludedPaths. As per our analysis we came to know that only from below three paths, it is getting indexed.
/var/workflow/instances - Runtime Workflow Model
/etc/workflow/instances - Old workflow instances before repo restructure
/var/taskmanagement - OOTB task management
So we thought of adding the above three paths in includedPaths property. Next time when we purge the workflow it will look only in these three paths instead of searching whole repository. Please let me know if we are going on a right track?.