SQL Performance (MOSC)

MOSC Banner

Drill down into views and find the join

edited Aug 19, 2019 6:04AM in SQL Performance (MOSC) 2 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center