Skip to content

Latest commit

 

History

History

xplan

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 
adv.sql
adv.sql
 
 
all.sql
all.sql
 
 
basic.sql
basic.sql
 
 
eg_trace.sql
eg_trace.sql
 
 
ind.sql
ind.sql
 
 
intro.sql
intro.sql
 
 
j1.lst
j1.lst
 
 
j1.sql
j1.sql
 
 
j2.lst
j2.lst
 
 
j2.sql
j2.sql
 
 
j3.lst
j3.lst
 
 
j3.sql
j3.sql
 
 
j4.lst
j4.lst
 
 
j4.sql
j4.sql
 
 
j5.lst
j5.lst
 
 
j5.sql
j5.sql
 
 
j6.lst
j6.lst
 
 
j6.sql
j6.sql
 
 
p_ind.sql
p_ind.sql
 
 
p_q2.lst
p_q2.lst
 
 
p_q2.sql
p_q2.sql
 
 
p_q7.lst
p_q7.lst
 
 
p_q7.sql
p_q7.sql
 
 
p_tabs.lst
p_tabs.lst
 
 
p_tabs.sql
p_tabs.sql
 
 
q0.lst
q0.lst
 
 
q0.sql
q0.sql
 
 
q1.lst
q1.lst
 
 
q1.sql
q1.sql
 
 
q2.lst
q2.lst
 
 
q2.sql
q2.sql
 
 
q3.lst
q3.lst
 
 
q3.sql
q3.sql
 
 
q4.lst
q4.lst
 
 
q4.sql
q4.sql
 
 
q5.lst
q5.lst
 
 
q5.sql
q5.sql
 
 
q6.lst
q6.lst
 
 
q6.sql
q6.sql
 
 
q7.lst
q7.lst
 
 
q7.sql
q7.sql
 
 
q8.lst
q8.lst
 
 
q8.sql
q8.sql
 
 
q9.lst
q9.lst
 
 
q9.sql
q9.sql
 
 
sa.sql
sa.sql
 
 
simple.sql
simple.sql
 
 
sta.sql
sta.sql
 
 
tabs.lst
tabs.lst
 
 
tabs.sql
tabs.sql
 
 
typ.sql
typ.sql
 
 

README.md

Scripts for playing with SQL execution plans

Some examples of how you can generate interesting SQL execution plans to help to unserstand how they work.

These scripts have been tested on Oracle Database 12c Release 2

DISCLAIMER:
-- These scripts are provided for educational purposes only.
-- They are NOT supported by Oracle World Wide Technical Support.
-- The scripts have been tested and they appear to work as intended.
-- You should always run scripts on a test instance.