For reasons not quite logical, the order of the from statements seems to make more difference than the order of the where clause. Changing the from clause to be:
acs_objects ao,
logger_entries le,
persons submitter
will likely give better performance. On my tests it made the acs_objects scan use the index.
** Martin
