AnsweredAssumed Answered

Database table size problems

Question asked by arpilz on Apr 6, 2010
Latest reply on Apr 7, 2010 by derek
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