Currently the CseScopeTransformer which works out where common sub expressions should be evaluated can take a pathological amount of time on some queries. While rewriting the mechanism may be a good long term goal, refactoring the code would provide short term benefits. (The time it takes is currently blocking other optimizations.)