Method R Discussion GroupMethod R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle. |
||
Discuss Method R products, techniques, and events. Ask new questions or post your own responses. |
dbms_xplain seems to account for query transformation...do you agree?
The query transformations are able to be determined by the plan operations that are chosen by the optimizer and by how the predicates are handled. All this is visible via the output from DBMS_XPLAN.
Since STAT lines don't include predicate information, that is one reason why it's good to have both the explain plan output and the STAT lines both. |
Powered by FogBugz