GitHub - pdvmoto/Part

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 48 Commits
2020_partitioning_v03.pptx		2020_partitioning_v03.pptx
README.txt		README.txt
abc.sql		abc.sql
demo_ddlck.sql		demo_ddlck.sql
demo_part.sql		demo_part.sql
demo_part_0.sql		demo_part_0.sql
demo_part_0a.sql		demo_part_0a.sql
demo_part_1.sql		demo_part_1.sql
demo_part_dtc.sql		demo_part_dtc.sql
demo_part_gip.sql		demo_part_gip.sql
demo_part_p1.sql		demo_part_p1.sql
demo_part_pk.sql		demo_part_pk.sql
demo_part_r1.sql		demo_part_r1.sql
demo_part_r2.sql		demo_part_r2.sql
demo_part_r3.sql		demo_part_r3.sql
demo_part_r4.sql		demo_part_r4.sql
demo_part_r4_t.sql		demo_part_r4_t.sql
demo_part_r4a.sql		demo_part_r4a.sql
demo_part_r5.sql		demo_part_r5.sql
demo_part_r6.sql		demo_part_r6.sql
demo_part_r7.sql		demo_part_r7.sql
demo_part_reset.sql		demo_part_reset.sql
demo_part_sum.sql		demo_part_sum.sql
demo_part_tt.sql		demo_part_tt.sql
notes.sql		notes.sql
pi.sql		pi.sql
show_redo.sql		show_redo.sql
show_redo_reset.sql		show_redo_reset.sql

Repository files navigation

These scripts go with the ppt on partitioning..

demo_part = initialize
demo_part_0 = drop-partition, redo.
demo_part_0a = drop, global index, redo..
demo_part_1 = 
demo_part_sum = show how summation over 1 partition is efficient


etc..


bonus1 : fabricate partiion key from Y-M-D+Seq..

bonus2: global_partitioned index: is NOT a local index... beware: demo_part_gip.sql

bonus3: tt = show how global index is not used on small partitions.