Toad / Oracle Explain Plan

oracle

http://www.morganslibrary.org/pres/lad10/peoug_xplan.pdf
http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-explain-the-explain-plan-052011-393674.pdf
https://docs.oracle.com/database/121/TGSQL/tgsql_interp.htm#TGSQL94717
https://blogs.oracle.com/optimizer/entry/displaying_and_reading_the_execution_plans_for_a_sql_statement
https://www.simple-talk.com/sql/performance/execution-plan-basics/

https://docs.oracle.com/database/121/TGSQL/tgsql_influence.htm#TGSQL246
https://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_plan.htm#g42231
https://blogs.oracle.com/optimizer/how-to-generate-a-useful-sql-execution-plan
https://richardfoote.wordpress.com/2010/02/16/how-does-an-execution-plan-suddenly-change-when-the-statistics-remain-the-same-in-limbo/
http://www.dba-oracle.com/t_adaptive_execution_plans.htm
http://www.dba-oracle.com/t_data_buffer_cache_sql_optimizer_execution_plan.htm
https://www.red-gate.com/simple-talk/sql/database-administration/exploring-query-plans-in-sql/
https://community.toadworld.com/products/toad-for-oracle/b/weblog/archive/2013/09/09/explain-plans-can-be-deceiving

https://community.oracle.com/thread/4116172
https://www.brentozar.com/archive/2016/11/query-sometimes-fast-sometimes-slow/
https://www.red-gate.com/simple-talk/sql/t-sql-programming/how-to-confuse-the-sql-server-query-optimizer/
https://support.sas.com/resources/papers/proceedings13/080-2013.pdf
https://www.morganslibrary.org/reference/hints.html
https://community.oracle.com/thread/3962827?start=15&tstart=0

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License