# Searchable Explain Plan

**URL:** <https://forums.toadworld.com/t/searchable-explain-plan/42103>\
**Category:** Idea Pond\
**Created:** [January 31, 2017, 4:02pm UTC](https://forums.toadworld.com/t/searchable-explain-plan/42103 "2017-01-31T16:02:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![phyllis.helton](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/phyllis.helton/32/10480_2.png) [@phyllis.helton](https://forums.toadworld.com/u/phyllis.helton)\
**Post date:** [January 31, 2017, 4:02pm UTC](https://forums.toadworld.com/t/searchable-explain-plan/42103/1 "2017-01-31T16:02:34Z")

</div>

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. &nbsp;I would love the ability to search the explain plan for:

1. &nbsp;Table or View names

2. &nbsp;Index names

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

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 27, 2017, 7:38pm UTC](https://forums.toadworld.com/t/searchable-explain-plan/42103/2 "2017-02-27T19:38:23Z")

</div>

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". &nbsp; That's for tree view. &nbsp; For DBMS\_XPLAN view, just do a CTRL+F to find.