Toad World® Forums

Searchable Explain Plan

Toad for Oracle Idea Pond
#1

I have to deal with a number of very complicated, stupidly written and poorly performing queries generated by OBIEE and so the explain plans I run often have well over 100 steps.  I would love the ability to search the explain plan for:

1.  Table or View names

2.  Index names

Maybe it is as simple as just letting me search for text within the description for the various steps.  If not, it would also be nice to be able to search by the type of join or table access (mostly TABLE ACCESS FULL)

#2

This isn't exactly searching, but if you want to quickly see what you're doing a full table scan on, right-click and choose "Show object usage".   That's for tree view.   For DBMS_XPLAN view, just do a CTRL+F to find.