589689.xyz

Cost-Based Oracle Foundaments

  • 收录时间:2018-03-19 20:04:27
  • 文件大小:40MB
  • 下载次数:227
  • 最近下载:2021-01-19 05:10:08
  • 磁力链接:
立即下载 复制链接

文件列表

  1. Jonathan Lewis - Cost-Based Oracle Foundaments - 2007.pdf 38MB
  2. samples/ch_13_merge/pat_nocpu.txt 159KB
  3. samples/ch_13_merge/sas_nocpu.txt 158KB
  4. samples/ch_13_merge/pat_cpu.txt 157KB
  5. samples/ch_13_merge/sas_cpu.txt 155KB
  6. samples/ch_12_hash/has_nocpu.txt 83KB
  7. samples/ch_12_hash/has_cpu.txt 79KB
  8. samples/ch_12_hash/pat_nocpu.txt 75KB
  9. samples/ch_12_hash/pat_cpu.txt 73KB
  10. samples/ch_14_10053/ch_14_10053_10.trc 62KB
  11. samples/ch_14_10053/ch_14_10053_09.trc 58KB
  12. samples/ch_14_10053/ch_14_10053_08.trc 41KB
  13. samples/ch_12_hash/d10g_hash.txt 39KB
  14. samples/ch_12_hash/hash_bad_10.txt 35KB
  15. samples/ch_12_hash/hash_bad_b_10.txt 34KB
  16. samples/ch_12_hash/hash_bad_08.txt 34KB
  17. samples/ch_12_hash/hash_bad_09.txt 34KB
  18. samples/ch_01_cost/view_merge_01_10.trc 34KB
  19. samples/ch_12_hash/hash_bad_b_09.txt 26KB
  20. samples/ch_12_hash/d920_hash.txt 23KB
  21. samples/ch_12_hash/d817_hash.txt 22KB
  22. samples/ch_01_cost/view_merge_01_08.trc 13KB
  23. samples/ch_09_transformations/unnest_cost_02.sql 11KB
  24. samples/ch_01_cost/view_merge_01_09.trc 11KB
  25. samples/ch_12_hash/hash_opt.sql 10KB
  26. samples/ch_09_transformations/push_subq.sql 9KB
  27. samples/ch_10_joins/join_card_08.sql 8KB
  28. samples/ch_12_hash/hash_one.sql 8KB
  29. samples/ch_06_selectivity_02/dependent.sql 7KB
  30. samples/ch_09_transformations/push_pred.sql 7KB
  31. samples/ch_10_joins/delete_anomaly.sql 7KB
  32. samples/ch_12_hash/hash_multi.sql 7KB
  33. samples/ch_13_merge/sort_demo_09.txt 7KB
  34. samples/ch_13_merge/sort_demo_10.txt 7KB
  35. samples/ch_13_merge/sort_demo_08.txt 7KB
  36. samples/ch_05_clustering/clufac_calc.sql 7KB
  37. samples/ch_06_selectivity_02/sysdate_10104.txt 7KB
  38. samples/ch_12_hash/hash_opt_a.sql 7KB
  39. samples/ch_06_selectivity_02/sysdate_9206.txt 6KB
  40. samples/ch_10_joins/join_card_09.sql 6KB
  41. samples/ch_07_histograms/c_skew_freq_10.txt 6KB
  42. samples/ch_07_histograms/c_skew_freq_09.txt 6KB
  43. samples/ch_07_histograms/c_skew_freq_08.txt 6KB
  44. samples/ch_06_selectivity_02/sysdate_8174.txt 6KB
  45. samples/ch_09_transformations/push_subq_10.txt 6KB
  46. samples/ch_09_transformations/filter_cost_02.LST 6KB
  47. samples/plan_run81.sql 6KB
  48. samples/ch_09_transformations/scalar_sub_01.sql 6KB
  49. samples/ch_09_transformations/push_subq_09.txt 6KB
  50. samples/ch_06_selectivity_02/sysdate_01.sql 6KB
  51. samples/ch_13_merge/set_ops_10.txt 6KB
  52. samples/ch_13_merge/sd_01a_10_30_08.txt 6KB
  53. samples/ch_09_transformations/push_subq_08.txt 6KB
  54. samples/ch_11_nl/join_cost_03a.sql 6KB
  55. samples/ch_02_tablescans/plan_run81.sql 6KB
  56. samples/ch_10_joins/join_card_05.sql 6KB
  57. samples/ch_12_hash/hash_one_bad.sql 6KB
  58. samples/ch_13_merge/set_ops_09.txt 6KB
  59. samples/ch_13_merge/agg_sort_2.sql 6KB
  60. samples/ch_13_merge/sd_01a_09_30_08.txt 5KB
  61. samples/ch_09_transformations/star_trans.sql 5KB
  62. samples/ch_02_tablescans/pq_anomaly.txt 5KB
  63. samples/ch_11_nl/join_cost_03.sql 5KB
  64. samples/ch_09_transformations/star_join_02.sql 5KB
  65. samples/ch_12_hash/hash_one_a.sql 5KB
  66. samples/ch_10_joins/join_card_01.sql 5KB
  67. samples/ch_09_transformations/star_trans_10.txt 5KB
  68. samples/ch_10_joins/type_demo.sql 5KB
  69. samples/ch_09_transformations/scalar_sub_03.sql 5KB
  70. samples/ch_14_10053/big_10053.sql 5KB
  71. samples/ch_09_transformations/ord_pred.sql 5KB
  72. samples/ch_12_hash/hash_stream_b.sql 5KB
  73. samples/ch_13_merge/sort_demo_01_09.txt 5KB
  74. samples/ch_13_merge/sd_01a_08_30_08.txt 5KB
  75. samples/ch_04_btree/btree_cost_02a.sql 5KB
  76. samples/ch_04_btree/btree_cost_02.sql 5KB
  77. samples/ch_13_merge/sd_01a_09_30_00.txt 5KB
  78. samples/ch_09_transformations/intersect_join.sql 5KB
  79. samples/ch_13_merge/sd_01a_10_30_00.txt 5KB
  80. samples/ch_10_joins/join_card_06.sql 5KB
  81. samples/ch_01_cost/first_rows.sql 5KB
  82. samples/ch_09_transformations/star_trans_09.txt 5KB
  83. samples/ch_09_transformations/star_trans_08.txt 4KB
  84. samples/ch_02_tablescans/tablescan_03.sql 4KB
  85. samples/ch_04_btree/rebuild_test.sql 4KB
  86. samples/ch_12_hash/hash_multi_a.sql 4KB
  87. samples/ch_08_bitmaps/bitmap_cost_01.sql 4KB
  88. samples/ch_11_nl/prefetch_test_02.sql 4KB
  89. samples/ch_07_histograms/c_skew_freq.sql 4KB
  90. samples/ch_06_selectivity_02/defaults.sql 4KB
  91. samples/ch_13_merge/gby_onekey.sql 4KB
  92. samples/ch_09_transformations/filter_cost_02.sql 4KB
  93. samples/ch_05_clustering/free_lists.sql 4KB
  94. samples/ch_06_selectivity_02/char_seq.sql 4KB
  95. samples/ch_10_joins/descending_bug.sql 4KB
  96. samples/ch_05_clustering/assm_test.sql 4KB
  97. samples/ch_06_selectivity_02/char_types.sql 4KB
  98. samples/ch_07_histograms/c_skew_freq_02.sql 4KB
  99. samples/ch_13_merge/sort_demo_01a.sql 4KB
  100. samples/ch_09_transformations/view_merge_01.sql 4KB
  101. samples/ch_01_cost/view_merge_01.sql 4KB
  102. samples/ch_02_tablescans/hack_stats.sql 4KB
  103. samples/ch_13_merge/merge_samples.sql 4KB
  104. samples/ch_06_selectivity_02/date_oddity.sql 4KB
  105. samples/ch_04_btree/hack_stats.sql 4KB
  106. samples/ch_13_merge/nosort.sql 4KB
  107. samples/ch_02_tablescans/plan_run92.sql 4KB
  108. samples/ch_02_tablescans/cpu_costing.sql 4KB
  109. samples/ch_13_merge/sd_01a_08_30_00.txt 4KB
  110. samples/ch_10_joins/hist_effect.sql 4KB
  111. samples/plan_run92.sql 4KB
  112. samples/ch_07_histograms/hist_intro.sql 4KB
  113. samples/ch_08_bitmaps/hack_stats.sql 4KB
  114. samples/ch_08_bitmaps/bitmap_cost_06.sql 4KB
  115. samples/ch_03_selectivity/hack_stats.sql 4KB
  116. samples/ch_07_histograms/hack_stats.sql 4KB
  117. samples/ch_06_selectivity_02/selectivity_one.sql 4KB
  118. samples/ch_03_selectivity/selectivity_one.sql 4KB
  119. samples/ch_06_selectivity_02/trans_close_02.sql 4KB
  120. samples/ch_12_hash/hash_stream_c.sql 4KB
  121. samples/ch_12_hash/hash_stream_d.sql 4KB
  122. samples/ch_06_selectivity_02/trans_close_03a.sql 4KB
  123. samples/ch_10_joins/join_card_04.sql 4KB
  124. samples/ch_12_hash/hash_stream_a.sql 4KB
  125. samples/ch_06_selectivity_02/trans_close_03.sql 4KB
  126. samples/ch_06_selectivity_02/constraint_01.sql 4KB
  127. samples/ch_05_clustering/base_line.sql 4KB
  128. samples/ch_13_merge/sort_demo_04.sql 4KB
  129. samples/ch_13_merge/merge_demo_01.sql 4KB
  130. samples/ch_03_selectivity/birth_month_01.sql 4KB
  131. samples/ch_06_selectivity_02/fun_sel.sql 4KB
  132. samples/ch_05_clustering/flg.sql 4KB
  133. samples/ch_02_tablescans/partition_2.sql 4KB
  134. samples/ch_05_clustering/hack_stats.sql 4KB
  135. samples/ch_10_joins/join_card_02a.sql 4KB
  136. samples/ch_07_histograms/fake_hist.sql 4KB
  137. samples/ch_08_bitmaps/bitmap_cost_03.sql 4KB
  138. samples/ch_10_joins/join_card_03.sql 4KB
  139. samples/ch_13_merge/sort_demo_01.sql 4KB
  140. samples/ch_02_tablescans/pq_anomaly.sql 4KB
  141. samples/ch_07_histograms/c_skew_freq_01.sql 4KB
  142. samples/ch_09_transformations/unnest_cost_01a.sql 4KB
  143. samples/ch_10_joins/join_card_10.sql 4KB
  144. samples/ch_13_merge/sort_demo_04a.sql 4KB
  145. samples/ch_08_bitmaps/bitmap_cost_03a.sql 4KB
  146. samples/ch_12_hash/hash_pat_bad.sql 4KB
  147. samples/ch_09_transformations/ordered.sql 4KB
  148. samples/ch_09_transformations/star_join.sql 4KB
  149. samples/ch_07_histograms/defaults.sql 4KB
  150. samples/ch_13_merge/merge_demo_01b.sql 4KB
  151. samples/ch_08_bitmaps/bitmap_cost_05.sql 3KB
  152. samples/ch_13_merge/merge_samples_c.sql 3KB
  153. samples/ch_05_clustering/reversed_ind.sql 3KB
  154. samples/ch_13_merge/sort_demo_02.sql 3KB
  155. samples/ch_09_transformations/with_subq_02.sql 3KB
  156. samples/ch_07_histograms/date_oddity.sql 3KB
  157. samples/ch_02_tablescans/tablescan_04.sql 3KB
  158. samples/ch_12_hash/hash_bad_b1.sql 3KB
  159. samples/ch_04_btree/btree_cost_01.sql 3KB
  160. samples/ch_04_btree/btree_cost_04.sql 3KB
  161. samples/ch_03_selectivity/like_test.sql 3KB
  162. samples/ch_09_transformations/push_pred_02.sql 3KB
  163. samples/ch_13_merge/sort_stream_a.sql 3KB
  164. samples/ch_06_selectivity_02/char_stats.sql 3KB
  165. samples/ch_06_selectivity_02/discrete_02.sql 3KB
  166. samples/ch_10_joins/join_card_02.sql 3KB
  167. samples/ch_11_nl/prefetch_test.sql 3KB
  168. samples/ch_13_merge/set_ops_08.txt 3KB
  169. samples/ch_06_selectivity_02/constraint_03.sql 3KB
  170. samples/ch_12_hash/hash_bad.txt 3KB
  171. samples/ch_03_selectivity/cross_column_02.sql 3KB
  172. samples/ch_09_transformations/scalar_sub_02.sql 3KB
  173. samples/ch_13_merge/join_card_01.sql 3KB
  174. samples/ch_06_selectivity_02/discrete_01.sql 3KB
  175. samples/ch_03_selectivity/cross_column_01.sql 3KB
  176. samples/ch_09_transformations/unnest_cost_03.sql 3KB
  177. samples/ch_06_selectivity_02/discrete_01a.sql 3KB
  178. samples/ch_07_histograms/c_skew_ht.sql 3KB
  179. samples/ch_09_transformations/semi_01.sql 3KB
  180. samples/ch_02_tablescans/partition.sql 3KB
  181. samples/ch_06_selectivity_02/discrete_02a.sql 3KB
  182. samples/ch_13_merge/sort_stream_c.sql 3KB
  183. samples/ch_09_transformations/unnest_cost_01b.sql 3KB
  184. samples/ch_08_bitmaps/bitmap_cost_04.sql 3KB
  185. samples/ch_09_transformations/filter_cost_01.sql 3KB
  186. samples/ch_10_joins/join_card_07.sql 3KB
  187. samples/ch_13_merge/set_ops.sql 3KB
  188. samples/ch_11_nl/join_cost_03b.sql 3KB
  189. samples/ch_07_histograms/dist_hist.sql 3KB
  190. samples/ch_04_btree/btree_cost_02_10_11000.txt 3KB
  191. samples/ch_09_transformations/anti_01.sql 3KB
  192. samples/ch_04_btree/btree_cost_02_10_9900.txt 3KB
  193. samples/ch_07_histograms/similar.sql 3KB
  194. samples/ch_08_bitmaps/bitmap_cost_02.sql 3KB
  195. samples/ch_13_merge/sort_stream_b.sql 3KB
  196. samples/ch_06_selectivity_02/trans_close_01.sql 3KB
  197. samples/ch_13_merge/sort_demo_01b.sql 3KB
  198. samples/ch_04_btree/btree_cost_02_10.txt 3KB
  199. samples/ch_06_selectivity_02/like_test.sql 3KB
  200. samples/ch_06_selectivity_02/trans_close_02b.sql 3KB
  201. samples/ch_04_btree/btree_cost_02_09.txt 3KB
  202. samples/ch_04_btree/btree_cost_02_08.txt 3KB
  203. samples/ch_02_tablescans/partition_8.sql 3KB
  204. samples/c_ts_test.sql 3KB
  205. samples/ch_13_merge/set_ops_a.sql 3KB
  206. samples/ch_02_tablescans/calc_mbrc.sql 3KB
  207. samples/ch_13_merge/agg_sort_2.trc 3KB
  208. samples/ch_13_merge/sort_stream_d.sql 3KB
  209. samples/ch_06_selectivity_02/dates_01.sql 3KB
  210. samples/ch_05_clustering/extra_col.sql 3KB
  211. samples/ch_02_tablescans/tablescan_01.sql 3KB
  212. samples/ch_09_transformations/book_subq.sql 3KB
  213. samples/ch_13_merge/gby_onekey_a.sql 3KB
  214. samples/ch_06_selectivity_02/nchar_types.sql 3KB
  215. samples/ch_12_hash/treble_hash.sql 3KB
  216. samples/ch_09_transformations/filter_cost.sql 3KB
  217. samples/ch_07_histograms/snap_myst.sql 3KB
  218. samples/ch_09_transformations/snap_myst.sql 3KB
  219. samples/ch_12_hash/snap_myst.sql 3KB
  220. samples/ch_13_merge/snap_myst.sql 3KB
  221. samples/ch_00_preface/in_list.sql 3KB
  222. samples/ch_12_hash/treble_hash_manual.sql 3KB
  223. samples/ch_09_transformations/filter_cost_01a.sql 3KB
  224. samples/ch_03_selectivity/ranges.sql 3KB
  225. samples/ch_08_bitmaps/bitmap_mbrc.sql 3KB
  226. samples/ch_01_cost/first_rows_09.txt 3KB
  227. samples/ch_13_merge/sort_demo_03a.sql 3KB
  228. samples/ch_06_selectivity_02/trans_close_02a.sql 3KB
  229. samples/ch_03_selectivity/in_list_02.sql 2KB
  230. samples/ch_08_bitmaps/bitmap_cost_08.sql 2KB
  231. samples/ch_08_bitmaps/bitmap_or.sql 2KB
  232. samples/ch_01_cost/first_rows_10.txt 2KB
  233. samples/ch_01_cost/first_rows_08.txt 2KB
  234. samples/ch_12_hash/treble_hash_auto.sql 2KB
  235. samples/ch_13_merge/sort_demo_03.sql 2KB
  236. samples/ch_13_merge/agg_sort.sql 2KB
  237. samples/ch_08_bitmaps/bitmap_cost_07.sql 2KB
  238. samples/ch_09_transformations/unnest_cost_01.sql 2KB
  239. samples/ch_13_merge/agg_sort_a.sql 2KB
  240. samples/ch_02_tablescans/tablescan_02.sql 2KB
  241. samples/ch_04_btree/btree_cost_05.sql 2KB
  242. samples/ch_13_merge/short_sort.sql 2KB
  243. samples/ch_06_selectivity_02/nchar_stats.sql 2KB
  244. samples/ch_09_transformations/with_subq_01.sql 2KB
  245. samples/ch_04_btree/btree_cost_03.sql 2KB
  246. samples/ch_06_selectivity_02/char_histograms.sql 2KB
  247. samples/ch_07_histograms/c_skew_ht_01.sql 2KB
  248. samples/ch_13_merge/cartesian.sql 2KB
  249. samples/ch_10_joins/join_card_01a.sql 2KB
  250. samples/ch_03_selectivity/birth_month_02.sql 2KB
  251. samples/ch_10_joins/join_card_09a.sql 2KB
  252. samples/ch_02_tablescans/index_ffs.sql 2KB
  253. samples/ch_09_transformations/semi_anti_01.sql 2KB
  254. samples/ch_01_cost/view_merge_01_10.txt 2KB
  255. samples/ch_03_selectivity/oddities.sql 2KB
  256. samples/ch_01_cost/view_merge_01_08.txt 2KB
  257. samples/ch_03_selectivity/in_list.sql 2KB
  258. samples/ch_07_histograms/hist_sel.sql 2KB
  259. samples/ch_11_nl/prefetch_test_01.sql 2KB
  260. samples/ch_01_cost/view_merge_01_09.txt 2KB
  261. samples/ch_02_tablescans/tablescan_01b.sql 2KB
  262. samples/ch_02_tablescans/tablescan_01a.sql 2KB
  263. samples/ch_03_selectivity/ranges_02.sql 2KB
  264. samples/ch_06_selectivity_02/dependent.txt 2KB
  265. samples/ch_09_transformations/filter_cost_01b.sql 2KB
  266. samples/ch_06_selectivity_02/constraint_02.sql 2KB
  267. samples/ch_05_clustering/col_order.sql 2KB
  268. samples/ch_09_transformations/notin.sql 2KB
  269. samples/ch_03_selectivity/two_predicate_01.sql 2KB
  270. samples/ch_03_selectivity/in_list_10g.sql 2KB
  271. samples/ch_02_tablescans/set_system_stats.sql 2KB
  272. samples/ch_03_selectivity/in_list_03.sql 2KB
  273. samples/ch_03_selectivity/bind_between.sql 2KB
  274. samples/ch_02_tablescans/parallel_2.sql 2KB
  275. samples/ch_06_selectivity_02/trans_close_01b.sql 2KB
  276. samples/ch_02_tablescans/parallel.sql 2KB
  277. samples/ch_05_clustering/setenv.sql 2KB
  278. samples/ch_06_selectivity_02/char_fun.sql 2KB
  279. samples/ch_12_hash/pat_cpu_harness.sql 2KB
  280. samples/ch_06_selectivity_02/setenv.sql 2KB
  281. samples/ch_07_histograms/setenv.sql 2KB
  282. samples/ch_08_bitmaps/setenv.sql 2KB
  283. samples/ch_09_transformations/setenv.sql 2KB
  284. samples/ch_11_nl/setenv.sql 2KB
  285. samples/ch_12_hash/setenv.sql 2KB
  286. samples/ch_13_merge/setenv.sql 2KB
  287. samples/ch_14_10053/setenv.sql 2KB
  288. samples/ch_00_preface/setenv.sql 2KB
  289. samples/ch_01_cost/setenv.sql 2KB
  290. samples/ch_02_tablescans/setenv.sql 2KB
  291. samples/ch_03_selectivity/setenv.sql 2KB
  292. samples/ch_04_btree/setenv.sql 2KB
  293. samples/setenv.sql 2KB
  294. samples/ch_10_joins/setenv.sql 2KB
  295. samples/ch_03_selectivity/ranges_10g.sql 1KB
  296. samples/ch_13_merge/pat_cpu_harness.sql 1KB
  297. samples/ch_03_selectivity/pv.sql 1KB
  298. samples/ch_13_merge/sas_cpu_harness.sql 1KB
  299. samples/ch_12_hash/has_cpu_harness.sql 1KB
  300. samples/ch_06_selectivity_02/trans_close_01a.sql 1KB
  301. samples/initd817.ora 1KB
  302. samples/ch_12_hash/pat_nocpu_harness.sql 1KB
  303. samples/initd920.ora 1KB
  304. samples/ch_06_selectivity_02/char_value.sql 1KB
  305. samples/ch_09_transformations/c_mystats.sql 1KB
  306. samples/ch_12_hash/c_mystats.sql 1KB
  307. samples/ch_13_merge/c_mystats.sql 1KB
  308. samples/ch_07_histograms/c_mystats.sql 1KB
  309. samples/ch_12_hash/has_nocpu_harness.sql 1KB
  310. samples/ch_13_merge/pat_nocpu_harness.sql 1KB
  311. samples/ch_13_merge/sas_nocpu_harness.sql 1KB
  312. samples/initd10g.ora 1KB
  313. samples/readme.txt 1KB
  314. samples/ch_06_selectivity_02/hist_calc.sql 1KB
  315. samples/ch_13_merge/pat_dump.sql 1KB
  316. samples/ch_13_merge/sas_dump.sql 998B
  317. samples/ch_12_hash/pat_dump.sql 954B
  318. samples/ch_12_hash/has_dump.sql 953B
  319. samples/ch_09_transformations/c_minmax.sql 861B
  320. samples/ch_05_clustering/reverse.sql 696B
  321. samples/ch_13_merge/set_system_stats.sql 678B