| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/dependent.sql |
7 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/sysdate_10104.txt |
7 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/sysdate_9206.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/sysdate_8174.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/sysdate_01.sql |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/defaults.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/char_seq.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/char_types.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/date_oddity.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/selectivity_one.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/trans_close_02.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/trans_close_03a.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/trans_close_03.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/constraint_01.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/fun_sel.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/char_stats.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/discrete_02.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/constraint_03.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/discrete_01.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/discrete_01a.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/discrete_02a.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/trans_close_01.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/like_test.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/trans_close_02b.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/dates_01.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/nchar_types.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/trans_close_02a.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/nchar_stats.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/char_histograms.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/dependent.txt |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/constraint_02.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/trans_close_01b.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/char_fun.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/trans_close_01a.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/char_value.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_06_selectivity_02/hist_calc.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/c_skew_freq_10.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/c_skew_freq_09.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/c_skew_freq_08.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/c_skew_freq.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/c_skew_freq_02.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/hist_intro.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/hack_stats.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/fake_hist.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/c_skew_freq_01.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/defaults.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/date_oddity.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/c_skew_ht.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/dist_hist.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/similar.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/snap_myst.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/c_skew_ht_01.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/hist_sel.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_07_histograms/c_mystats.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_cost_01.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/hack_stats.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_cost_06.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_cost_03.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_cost_03a.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_cost_05.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_cost_04.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_cost_02.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_mbrc.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_cost_08.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_or.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/bitmap_cost_07.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_08_bitmaps/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/unnest_cost_02.sql |
11 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/push_subq.sql |
9 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/push_pred.sql |
7 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/push_subq_10.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/filter_cost_02.LST |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/scalar_sub_01.sql |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/push_subq_09.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/push_subq_08.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/star_trans.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/star_join_02.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/star_trans_10.txt |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/scalar_sub_03.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/ord_pred.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/intersect_join.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/star_trans_09.txt |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/star_trans_08.txt |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/filter_cost_02.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/view_merge_01.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/unnest_cost_01a.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/ordered.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/star_join.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/with_subq_02.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/push_pred_02.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/scalar_sub_02.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/unnest_cost_03.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/semi_01.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/unnest_cost_01b.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/filter_cost_01.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/anti_01.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/book_subq.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/filter_cost.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/snap_myst.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/filter_cost_01a.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/unnest_cost_01.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/with_subq_01.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/semi_anti_01.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/filter_cost_01b.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/notin.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/c_mystats.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_09_transformations/c_minmax.sql |
861 B |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_08.sql |
8 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/delete_anomaly.sql |
7 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_09.sql |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_05.sql |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_01.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/type_demo.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_06.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/descending_bug.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/hist_effect.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_04.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_02a.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_03.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_10.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_02.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_07.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_01a.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/join_card_09a.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_10_joins/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_11_nl/join_cost_03a.sql |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_11_nl/join_cost_03.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_11_nl/prefetch_test_02.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_11_nl/prefetch_test.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_11_nl/join_cost_03b.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_11_nl/prefetch_test_01.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_11_nl/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/has_nocpu.txt |
83 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/has_cpu.txt |
79 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/pat_nocpu.txt |
75 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/pat_cpu.txt |
73 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/d10g_hash.txt |
39 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_bad_10.txt |
35 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_bad_b_10.txt |
34 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_bad_08.txt |
34 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_bad_09.txt |
34 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_bad_b_09.txt |
26 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/d920_hash.txt |
23 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/d817_hash.txt |
22 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_opt.sql |
10 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_one.sql |
8 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_multi.sql |
7 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_opt_a.sql |
7 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_one_bad.sql |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_one_a.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_stream_b.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_multi_a.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_stream_c.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_stream_d.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_stream_a.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_pat_bad.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_bad_b1.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/hash_bad.txt |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/treble_hash.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/snap_myst.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/treble_hash_manual.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/treble_hash_auto.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/pat_cpu_harness.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/has_cpu_harness.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/pat_nocpu_harness.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/c_mystats.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/has_nocpu_harness.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/pat_dump.sql |
954 B |
| Cost-Based Oracle Foundaments/samples/ch_12_hash/has_dump.sql |
953 B |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/pat_nocpu.txt |
159 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sas_nocpu.txt |
158 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/pat_cpu.txt |
157 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sas_cpu.txt |
155 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_09.txt |
7 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_10.txt |
7 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_08.txt |
7 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/set_ops_10.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sd_01a_10_30_08.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/set_ops_09.txt |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/agg_sort_2.sql |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sd_01a_09_30_08.txt |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_01_09.txt |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sd_01a_08_30_08.txt |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sd_01a_09_30_00.txt |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sd_01a_10_30_00.txt |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/gby_onekey.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_01a.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/merge_samples.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/nosort.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sd_01a_08_30_00.txt |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_04.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/merge_demo_01.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_01.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_04a.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/merge_demo_01b.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/merge_samples_c.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_02.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_stream_a.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/set_ops_08.txt |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/join_card_01.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_stream_c.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/set_ops.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_stream_b.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_01b.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/set_ops_a.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/agg_sort_2.trc |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_stream_d.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/gby_onekey_a.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/snap_myst.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_03a.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sort_demo_03.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/agg_sort.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/agg_sort_a.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/short_sort.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/cartesian.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/pat_cpu_harness.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sas_cpu_harness.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/c_mystats.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/pat_nocpu_harness.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sas_nocpu_harness.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/pat_dump.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/sas_dump.sql |
998 B |
| Cost-Based Oracle Foundaments/samples/ch_13_merge/set_system_stats.sql |
678 B |
| Cost-Based Oracle Foundaments/samples/ch_14_10053/ch_14_10053_10.trc |
62 KB |
| Cost-Based Oracle Foundaments/samples/ch_14_10053/ch_14_10053_09.trc |
58 KB |
| Cost-Based Oracle Foundaments/samples/ch_14_10053/ch_14_10053_08.trc |
41 KB |
| Cost-Based Oracle Foundaments/samples/ch_14_10053/big_10053.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_14_10053/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_00_preface/in_list.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_00_preface/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/view_merge_01_10.trc |
34 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/view_merge_01_08.trc |
13 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/view_merge_01_09.trc |
11 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/first_rows.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/view_merge_01.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/first_rows_09.txt |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/first_rows_10.txt |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/first_rows_08.txt |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/view_merge_01_10.txt |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/view_merge_01_08.txt |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/view_merge_01_09.txt |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_01_cost/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/plan_run81.sql |
6 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/pq_anomaly.txt |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/tablescan_03.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/hack_stats.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/plan_run92.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/cpu_costing.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/partition_2.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/pq_anomaly.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/tablescan_04.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/partition.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/partition_8.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/calc_mbrc.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/tablescan_01.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/tablescan_02.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/index_ffs.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/tablescan_01b.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/tablescan_01a.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/set_system_stats.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/parallel_2.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/parallel.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_02_tablescans/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/hack_stats.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/selectivity_one.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/birth_month_01.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/like_test.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/cross_column_02.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/cross_column_01.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/ranges.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/in_list_02.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/birth_month_02.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/oddities.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/in_list.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/ranges_02.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/two_predicate_01.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/in_list_10g.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/in_list_03.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/bind_between.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/ranges_10g.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_03_selectivity/pv.sql |
1 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_02a.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_02.sql |
5 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/rebuild_test.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/hack_stats.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_01.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_04.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_02_10_11000.txt |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_02_10_9900.txt |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_02_10.txt |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_02_09.txt |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_02_08.txt |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_05.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/btree_cost_03.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_04_btree/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/clufac_calc.sql |
7 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/free_lists.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/assm_test.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/base_line.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/flg.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/hack_stats.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/reversed_ind.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/extra_col.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/col_order.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/ch_05_clustering/reverse.sql |
696 B |
| Cost-Based Oracle Foundaments/samples/plan_run81.sql |
6 KB |
| Cost-Based Oracle Foundaments/samples/plan_run92.sql |
4 KB |
| Cost-Based Oracle Foundaments/samples/c_ts_test.sql |
3 KB |
| Cost-Based Oracle Foundaments/samples/setenv.sql |
2 KB |
| Cost-Based Oracle Foundaments/samples/initd817.ora |
1 KB |
| Cost-Based Oracle Foundaments/samples/initd920.ora |
1 KB |
| Cost-Based Oracle Foundaments/samples/initd10g.ora |
1 KB |
| Cost-Based Oracle Foundaments/samples/readme.txt |
1 KB |
| Cost-Based Oracle Foundaments/Jonathan Lewis - Cost-Based Oracle Foundaments - 2007.pdf |
37.9 MB |
Magnet link
