Drill down into views and find the join
Hi
Our application is using a lot of views.
So ,often I find myself reviewing an execution plan and I notice a join which seems to cause the performance issue.
Next step ,in my case, is to find out which view is the source of this join.
I never seem to find them fast and I have to look into the nested views and look for the join.
So, the question is how can I identify what part of the sql is the source of the join?
In other words,I need to know and understand how the joins are generated from the views?