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)