Instead of carefully investigate which fields should have an index (all fields used for joins) the brute strategy is to index them all :P