Skip to content

Files

Latest commit

nigelbaylissnigelbayliss
expression stats example (#169)
Aug 9, 2021
13322b7 · Aug 9, 2021

History

History

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
column_groups
column_groups
Jul 21, 2021
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
expression_stats
expression_stats
Aug 9, 2021
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
Jun 8, 2021
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