We are running an oracle back-end for our alfresco DB and are running in to some performance issues. We have a query that does an outer join on avm_nodes and avm_child_entries .
two tables being compared avm_nodes ~2.5m records
and avm_child_entries ~22m
make the simple query take ~25s to run.
I am wondering if any other user has run in to this issue before, and what can be done about it. As far as i know we cannot clean these tables without purging history, but I would like to hear what others have done to resolve this issue.
thanks in advance
Andrew
