I've started a new job and am looking at some of their views that they wanted me to get familiar with.

One of the views that I'm going through has **54 SELECTs**. I've NEVER seen such a massive View before and after browsing through it, I'm fairly certain that I can optimize it.

What I'm looking for is an easier way to compare the JOINs between each of the selects to find commonality WITHOUT just having to sift through them all by hand.

I'm fairly certain that THAT is what I'll have to do, but I was hoping that someone would have an easier or more efficient and less time consuming way to do this...

Anyone? :)