creating index (unique or duplicate) on case_reporter2site will help.

- Rajeev