you might know Kerry´s classic blog:
Normally my work around for explain plan issues is to run the query and use
Now I am working in an environment where I must not run a query, but I can do
But still I think I can not tolerate explain plan weaknesses.
I think it should be possble to use DBMS_SQL to parse a statement and receive a
proper plan without actually running the statement.
Then use dbms_xplan.display_cursor.
Before I spent time, has anybody done it already?