loading...

re: Ways of Seeing: ORMS & SQL Views VIEW POST

TOP OF THREAD FULL DISCUSSION
re: There's the query plan analyzer built into SQL Developer, though I'm not sure if that's what you're looking for
 

Was looking more for an interactive parser similar to the above that does a good job of breaking down each join and which ones stand out as larger problems from everything else (visually). Even with Query Plan Analyzer / DBMS_XPLAN it can get pretty hectic, especially when it starts introducing bitmap and hash joins, and if you have a lot of tables even the indented table tree view can be unwieldy after a certain depth.

code of conduct - report abuse