Cost Based Oracle Foundaments | 0924C75D16165ED1C2631D7103F6123F831EFFD6

Cost Based Oracle Foundaments

Name	Cost-Based Oracle Foundaments	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	42.2 MB
Total Files	321
Hash	0924C75D16165ED1C2631D7103F6123F831EFFD6

/.../ch_06_selectivity_02/
dependent.sql	7.6 KB
sysdate_10104.txt	6.8 KB
sysdate_9206.txt	6.6 KB
sysdate_8174.txt	6.4 KB
sysdate_01.sql	6.3 KB
defaults.sql	4.4 KB
char_seq.sql	4.3 KB
char_types.sql	4.2 KB
date_oddity.sql	4.1 KB
selectivity_one.sql	4.0 KB
trans_close_02.sql	4.0 KB
trans_close_03a.sql	4.0 KB
trans_close_03.sql	3.9 KB
constraint_01.sql	3.9 KB
fun_sel.sql	3.9 KB
char_stats.sql	3.3 KB
discrete_02.sql	3.3 KB
constraint_03.sql	3.2 KB
discrete_01.sql	3.1 KB
discrete_01a.sql	3.1 KB
discrete_02a.sql	3.1 KB
trans_close_01.sql	2.9 KB
like_test.sql	2.9 KB
trans_close_02b.sql	2.9 KB
dates_01.sql	2.7 KB
nchar_types.sql	2.7 KB
trans_close_02a.sql	2.6 KB
nchar_stats.sql	2.3 KB
char_histograms.sql	2.2 KB
dependent.txt	2.0 KB
constraint_02.sql	2.0 KB
trans_close_01b.sql	1.6 KB
char_fun.sql	1.6 KB
setenv.sql	1.5 KB
trans_close_01a.sql	1.4 KB
char_value.sql	1.4 KB
hist_calc.sql	1.1 KB
/.../ch_07_histograms/
c_skew_freq_10.txt	6.5 KB
c_skew_freq_09.txt	6.5 KB
c_skew_freq_08.txt	6.5 KB
c_skew_freq.sql	4.4 KB
c_skew_freq_02.sql	4.2 KB
hist_intro.sql	4.1 KB
hack_stats.sql	4.0 KB
fake_hist.sql	3.8 KB
c_skew_freq_01.sql	3.7 KB
defaults.sql	3.6 KB
date_oddity.sql	3.4 KB
c_skew_ht.sql	3.1 KB
dist_hist.sql	3.0 KB
similar.sql	3.0 KB
snap_myst.sql	2.7 KB
c_skew_ht_01.sql	2.2 KB
hist_sel.sql	2.1 KB
setenv.sql	1.5 KB
c_mystats.sql	1.3 KB
/.../ch_08_bitmaps/
bitmap_cost_01.sql	4.5 KB
hack_stats.sql	4.1 KB
bitmap_cost_06.sql	4.0 KB
bitmap_cost_03.sql	3.8 KB
bitmap_cost_03a.sql	3.6 KB
bitmap_cost_05.sql	3.6 KB
bitmap_cost_04.sql	3.0 KB
bitmap_cost_02.sql	2.9 KB
bitmap_mbrc.sql	2.6 KB
bitmap_cost_08.sql	2.5 KB
bitmap_or.sql	2.5 KB
bitmap_cost_07.sql	2.4 KB
setenv.sql	1.5 KB
/.../ch_09_transformations/
unnest_cost_02.sql	11.7 KB
push_subq.sql	8.9 KB
push_pred.sql	7.6 KB
push_subq_10.txt	6.4 KB
filter_cost_02.LST	6.4 KB
scalar_sub_01.sql	6.4 KB
push_subq_09.txt	6.3 KB
push_subq_08.txt	6.1 KB
star_trans.sql	5.6 KB
star_join_02.sql	5.5 KB
star_trans_10.txt	5.2 KB
scalar_sub_03.sql	5.1 KB
ord_pred.sql	5.0 KB
intersect_join.sql	4.8 KB
star_trans_09.txt	4.6 KB
star_trans_08.txt	4.6 KB
filter_cost_02.sql	4.3 KB
view_merge_01.sql	4.2 KB
unnest_cost_01a.sql	3.7 KB
ordered.sql	3.6 KB
star_join.sql	3.6 KB
with_subq_02.sql	3.5 KB
push_pred_02.sql	3.3 KB
scalar_sub_02.sql	3.2 KB
unnest_cost_03.sql	3.1 KB
semi_01.sql	3.1 KB
unnest_cost_01b.sql	3.0 KB
filter_cost_01.sql	3.0 KB
anti_01.sql	3.0 KB
book_subq.sql	2.7 KB
filter_cost.sql	2.7 KB
snap_myst.sql	2.7 KB
filter_cost_01a.sql	2.6 KB
unnest_cost_01.sql	2.4 KB
with_subq_01.sql	2.3 KB
semi_anti_01.sql	2.2 KB
filter_cost_01b.sql	2.0 KB
notin.sql	2.0 KB
setenv.sql	1.5 KB
c_mystats.sql	1.3 KB
c_minmax.sql	0.9 KB
/.../ch_10_joins/
join_card_08.sql	8.0 KB
delete_anomaly.sql	7.1 KB
join_card_09.sql	6.6 KB
join_card_05.sql	6.0 KB
join_card_01.sql	5.2 KB
type_demo.sql	5.1 KB
join_card_06.sql	4.7 KB
descending_bug.sql	4.3 KB
hist_effect.sql	4.1 KB
join_card_04.sql	3.9 KB
join_card_02a.sql	3.8 KB
join_card_03.sql	3.8 KB
join_card_10.sql	3.7 KB
join_card_02.sql	3.3 KB
join_card_07.sql	3.0 KB
join_card_01a.sql	2.2 KB
join_card_09a.sql	2.2 KB
setenv.sql	1.5 KB
/.../ch_11_nl/
join_cost_03a.sql	6.1 KB
join_cost_03.sql	5.5 KB
prefetch_test_02.sql	4.5 KB
prefetch_test.sql	3.2 KB
join_cost_03b.sql	3.0 KB
prefetch_test_01.sql	2.1 KB
setenv.sql	1.5 KB
/.../ch_12_hash/
has_nocpu.txt	85.1 KB
has_cpu.txt	81.3 KB
pat_nocpu.txt	76.3 KB
pat_cpu.txt	74.3 KB
d10g_hash.txt	39.8 KB
hash_bad_10.txt	35.5 KB
hash_bad_b_10.txt	35.3 KB
hash_bad_08.txt	35.3 KB
hash_bad_09.txt	35.3 KB
hash_bad_b_09.txt	26.3 KB
d920_hash.txt	23.8 KB
d817_hash.txt	22.1 KB
hash_opt.sql	10.0 KB
hash_one.sql	7.9 KB
hash_multi.sql	7.1 KB
hash_opt_a.sql	6.7 KB
hash_one_bad.sql	6.0 KB
hash_one_a.sql	5.3 KB
hash_stream_b.sql	5.0 KB
hash_multi_a.sql	4.5 KB
hash_stream_c.sql	4.0 KB
hash_stream_d.sql	4.0 KB
hash_stream_a.sql	3.9 KB
hash_pat_bad.sql	3.6 KB
hash_bad_b1.sql	3.4 KB
hash_bad.txt	3.2 KB
treble_hash.sql	2.7 KB
snap_myst.sql	2.7 KB
treble_hash_manual.sql	2.6 KB
treble_hash_auto.sql	2.5 KB
pat_cpu_harness.sql	1.6 KB
setenv.sql	1.5 KB
has_cpu_harness.sql	1.5 KB
pat_nocpu_harness.sql	1.4 KB
c_mystats.sql	1.3 KB
has_nocpu_harness.sql	1.3 KB
pat_dump.sql	1.0 KB
has_dump.sql	1.0 KB
/.../ch_13_merge/
pat_nocpu.txt	162.3 KB
sas_nocpu.txt	162.1 KB
pat_cpu.txt	160.3 KB
sas_cpu.txt	158.5 KB
sort_demo_09.txt	7.0 KB
sort_demo_10.txt	7.0 KB
sort_demo_08.txt	7.0 KB
set_ops_10.txt	6.2 KB
sd_01a_10_30_08.txt	6.2 KB
set_ops_09.txt	6.0 KB
agg_sort_2.sql	5.9 KB
sd_01a_09_30_08.txt	5.6 KB
sort_demo_01_09.txt	4.9 KB
sd_01a_08_30_08.txt	4.9 KB
sd_01a_09_30_00.txt	4.8 KB
sd_01a_10_30_00.txt	4.7 KB
gby_onekey.sql	4.3 KB
sort_demo_01a.sql	4.2 KB
merge_samples.sql	4.1 KB
nosort.sql	4.1 KB
sd_01a_08_30_00.txt	4.1 KB
sort_demo_04.sql	3.9 KB
merge_demo_01.sql	3.9 KB
sort_demo_01.sql	3.8 KB
sort_demo_04a.sql	3.7 KB
merge_demo_01b.sql	3.6 KB
merge_samples_c.sql	3.5 KB
sort_demo_02.sql	3.5 KB
sort_stream_a.sql	3.3 KB
set_ops_08.txt	3.2 KB
join_card_01.sql	3.2 KB
sort_stream_c.sql	3.1 KB
set_ops.sql	3.0 KB
sort_stream_b.sql	2.9 KB
sort_demo_01b.sql	2.9 KB
set_ops_a.sql	2.8 KB
agg_sort_2.trc	2.8 KB
sort_stream_d.sql	2.8 KB
gby_onekey_a.sql	2.7 KB
snap_myst.sql	2.7 KB
sort_demo_03a.sql	2.6 KB
sort_demo_03.sql	2.5 KB
agg_sort.sql	2.5 KB
agg_sort_a.sql	2.4 KB
short_sort.sql	2.3 KB
cartesian.sql	2.2 KB
setenv.sql	1.5 KB
pat_cpu_harness.sql	1.5 KB
sas_cpu_harness.sql	1.5 KB
c_mystats.sql	1.3 KB
pat_nocpu_harness.sql	1.3 KB
sas_nocpu_harness.sql	1.3 KB
pat_dump.sql	1.0 KB
sas_dump.sql	1.0 KB
set_system_stats.sql	0.7 KB
/.../ch_14_10053/
ch_14_10053_10.trc	63.9 KB
ch_14_10053_09.trc	59.5 KB
ch_14_10053_08.trc	42.3 KB
big_10053.sql	5.1 KB
setenv.sql	1.5 KB
/.../ch_00_preface/
in_list.sql	2.7 KB
setenv.sql	1.5 KB
/.../ch_01_cost/
view_merge_01_10.trc	35.1 KB
view_merge_01_08.trc	13.7 KB
view_merge_01_09.trc	10.9 KB
first_rows.sql	4.7 KB
view_merge_01.sql	4.2 KB
first_rows_09.txt	2.6 KB
first_rows_10.txt	2.5 KB
first_rows_08.txt	2.5 KB
view_merge_01_10.txt	2.1 KB
view_merge_01_08.txt	2.1 KB
view_merge_01_09.txt	2.1 KB
setenv.sql	1.5 KB
/.../ch_02_tablescans/
plan_run81.sql	6.0 KB
pq_anomaly.txt	5.5 KB
tablescan_03.sql	4.5 KB
hack_stats.sql	4.1 KB
plan_run92.sql	4.1 KB
cpu_costing.sql	4.1 KB
partition_2.sql	3.8 KB
pq_anomaly.sql	3.7 KB
tablescan_04.sql	3.4 KB
partition.sql	3.1 KB
partition_8.sql	2.8 KB
calc_mbrc.sql	2.8 KB
tablescan_01.sql	2.7 KB
tablescan_02.sql	2.3 KB
index_ffs.sql	2.2 KB
tablescan_01b.sql	2.0 KB
tablescan_01a.sql	2.0 KB
set_system_stats.sql	1.9 KB
parallel_2.sql	1.7 KB
parallel.sql	1.6 KB
setenv.sql	1.5 KB
/.../ch_03_selectivity/
hack_stats.sql	4.0 KB
selectivity_one.sql	4.0 KB
birth_month_01.sql	3.9 KB
like_test.sql	3.3 KB
cross_column_02.sql	3.2 KB
cross_column_01.sql	3.1 KB
ranges.sql	2.6 KB
in_list_02.sql	2.6 KB
birth_month_02.sql	2.2 KB
oddities.sql	2.1 KB
in_list.sql	2.1 KB
ranges_02.sql	2.0 KB
two_predicate_01.sql	1.9 KB
in_list_10g.sql	1.9 KB
in_list_03.sql	1.9 KB
bind_between.sql	1.9 KB
setenv.sql	1.5 KB
ranges_10g.sql	1.5 KB
pv.sql	1.5 KB
/.../ch_04_btree/
btree_cost_02a.sql	4.9 KB
btree_cost_02.sql	4.8 KB
rebuild_test.sql	4.5 KB
hack_stats.sql	4.1 KB
btree_cost_01.sql	3.4 KB
btree_cost_04.sql	3.3 KB
btree_cost_02_10_11000.txt	3.0 KB
btree_cost_02_10_9900.txt	3.0 KB
btree_cost_02_10.txt	2.9 KB
btree_cost_02_09.txt	2.9 KB
btree_cost_02_08.txt	2.9 KB
btree_cost_05.sql	2.3 KB
btree_cost_03.sql	2.3 KB
setenv.sql	1.5 KB
/.../ch_05_clustering/
clufac_calc.sql	6.8 KB
free_lists.sql	4.3 KB
assm_test.sql	4.2 KB
base_line.sql	3.9 KB
flg.sql	3.9 KB
hack_stats.sql	3.8 KB
reversed_ind.sql	3.5 KB
extra_col.sql	2.7 KB
col_order.sql	2.0 KB
setenv.sql	1.6 KB
reverse.sql	0.7 KB
/samples/
plan_run81.sql	6.4 KB
plan_run92.sql	4.1 KB
c_ts_test.sql	2.8 KB
setenv.sql	1.5 KB
initd817.ora	1.4 KB
initd920.ora	1.4 KB
initd10g.ora	1.3 KB
readme.txt	1.2 KB
/
Jonathan Lewis - Cost-Based Oracle Foundaments - 2007.pdf	39.7 MB
Total files 321