Oracle Optimizer
Other Useful Pages
on this siteSELECT sql_id, child_number, sql_text
FROM v$sql
WHERE sql_id = '&SQLID'
Bibliography
Bibliography
http://allthingsoracle.com/tag/execution-plans/ https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:231814117467#7344298017927https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:7807480400346035212https://blogs.oracle.com/optimizer/how-to-generate-a-useful-sql-execution-planhttps://oracle-base.com/articles/10g/automatic-sql-tuning-10g
https://stackoverflow.com/questions/50324949/oracle-analyze-table-vs-gather-table-stats-vs-gather-schema-statshttps://docs.oracle.com/database/121/SQLRF/statements_4005.htm
Database Performance Tuning Guidehttps://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_tune.htm