Have you considered creating Aggregate Join Indexes for your query?
Attachments
Library
Quick Reference
Archives
Sample Index
2011 Indexes