RM Query select_NodeIdsWhichReferenceContentUrl performance issue

[mrudev]

The query select_NodeIdsWhichReferenceContentUrl defined in RM file config\alfresco\module\org_alfresco_module_rm\query\rm-common-SqlMap.xml takes very long to execute on a production database (the amount of data in the database needs to be significantly large to reproduce the issue). It can take anywhere between 20 and 45 minutes. Which makes sense to me, seeing that one of the joins is done on a column which is not an index (alf_node_properties.long_value).

The result is that the "destroy" action on each record takes really long to complete.