Blog48.8K views760 votes0 replies1,354 following
Explain Plan vs. Autotrace in SQL Developer: Stop Tuning on Predictions
SQL Developer's Explain Plan shows an optimizer prediction; Autotrace shows what actually ran. A practical workflow for validating query rewrites using consistent gets, plan comparison, and DBMS_XPLAN.
sqldeveloper