Skip to content

Files

Latest commit

PhilippSalvisbergPhilippSalvisberg
remove invalid table reference tab2 in use_hash hint
Sep 11, 2020
785b0db · Sep 11, 2020

History

History
This branch is 239 commits behind oracle-samples/oracle-db-examples:main.

optimizer

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
RWPG
RWPG
Dec 9, 2019
att_clu_zone_map
att_clu_zone_map
Feb 28, 2017
autonomous
autonomous
Apr 2, 2019
bulk_load
bulk_load
Feb 28, 2017
compare_ofe
compare_ofe
Feb 28, 2017
creative_w_plan
creative_w_plan
Sep 11, 2020
db_load
db_load
Feb 28, 2017
direct_path
direct_path
Feb 28, 2017
execution_plans/part0
execution_plans/part0
Apr 25, 2018
faster_stats
faster_stats
Jun 18, 2020
fine_grained
fine_grained
Jun 20, 2018
first_rows
first_rows
Oct 29, 2018
gather_stale
gather_stale
Mar 20, 2018
histogram_history
histogram_history
Jun 14, 2019
new_synopses
new_synopses
May 30, 2019
partition_exchange_load
partition_exchange_load
Feb 28, 2017
px_wm_wp
px_wm_wp
Feb 28, 2017
spm
spm
Feb 28, 2017
spm_19c_debug
spm_19c_debug
Feb 21, 2019
spm_fix
spm_fix
Jan 3, 2020
spm_in_practice
spm_in_practice
May 23, 2018
spm_on_11g
spm_on_11g
Apr 12, 2017
spm_plan_control
spm_plan_control
Jun 18, 2020
stale_reason
stale_reason
Nov 23, 2018
tcb
tcb
Nov 26, 2019
topn
topn
Jun 18, 2020
tpcds_etabs
tpcds_etabs
May 14, 2019
upgrading_to_12c
upgrading_to_12c
Jun 17, 2019
xplan
xplan
Nov 20, 2018
LICENCE.md
LICENCE.md
Feb 28, 2017
README.md
README.md
Feb 28, 2017

README.md

This is a top level repository for code examples related to the Oracle Optimizer and, occasionally, Data Warehousing and Very Large Databases.

The examples are generally self-contained, each wthin a directory containing all the scripts you'll need to complete a particular example. The scripts can be executed using SQL Plus or Oracle SQL Developer.

Many of the scripts are referenced from the Oracle Optimizer Blog, here: https://blogs.oracle.com/optimizer