How can I make TOAD explain plan (from SQL editor) show access and filter predicates?
Right click the explain plan | Adjust content | Check Access Predicates and Filter Predicates visible does not help.
Note: Session Browser | Current Statement | Explain Plan, actually shows access and filter predicates (but only for a running statement).
Delete the old explian plan table .
If you still can't get that to show up, you may have an old explain plan table that didn't have those columns. If that is the case, you can delete the table (and drop the synonym for it, if there is one), then let Toad recreate it.
Excerpt from Help | Hints and Tips: Explain Plan Tables
"Toad expects to find an Explain Plan table with columns to match the most recent specification from Oracle.
If you get "Invalid Column" errors when executing Explain Plan, you can recreate the explain plan tables using the Server Side Install wizard.
The Plan Table can be set in the View | Toad Options | Oracle tab, Explain Plan Table Name: box."
