loading...

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

FULL DISCUSSION
 

Depesz's tool for explaining EXPLAIN output looks fantastic for PostgreSQL -- is there a similar tool for Oracle plans?

 

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