今天总结了一下分区表的知识分享一下。大体有以下内容:1.hash partition range partition list partition range hash partition range list partitio2.partition operations add ,truncate,drop partitions merge ,move ,split partitions &nb...【阅读全文】
续接上次的分区表学习笔记,对分区索引进行了总结。--index maintanceSQL> select index_name,table_name from user_indexes where table_name='RANGE_PART';no rows selected--create one global indexSQL> create index glb_range_part on range_part(a,b) 2 global partition by range(a) 3 ...【阅读全文】
今天总结了一下分区表的知识分享一下。大体有以下内容:1.hash partition range partition list partition range hash partition range list partitio2.partition operations add ,truncate,drop partitions merge ,move ,split partitions &nb...【阅读全文】
续接上次的分区表学习笔记,对分区索引进行了总结。--index maintanceSQL> select index_name,table_name from user_indexes where table_name='RANGE_PART';no rows selected--create one global indexSQL> create index glb_range_part on range_part(a,b) 2 global partition by range(a) 3 ...【阅读全文】