Years ago I did some really fun query optimization with their aggregate query tool that got a monthly process from a theoretical month-long runtime down to a few hours. I felt like hackerman

(the most important change was slightly reorganizing the data)