Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to build the ORACLE10g global HASH partition index". In the daily operation, I believe many people have doubts about how to build the ORACLE10g global HASH partition index. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how to build the ORACLE10g global HASH partition index". Next, please follow the editor to study!

Prior to 10g, there was only one global index partitioning method for Oracle, that is, range partitioning.

SQL > CREATE TABLE T_PART_INDEX (ID NUMBER, NAME VARCHAR2 (30), CREATE_DATE DATE)

The table has been created.

SQL > INSERT INTO T_PART_INDEX SELECT ROWNUM, OBJECT_NAME, CREATED FROM DBA_OBJECTS

57477 rows were created.

SQL > COMMIT

The submission is complete.

SQL > CREATE INDEX IND_PART_INDEX_CREATE

2 ON T_PART_INDEX (CREATE_DATE) GLOBAL

3 PARTITION BY RANGE (CREATE_DATE)

4 (PARTITION P1 VALUES LESS THAN (TO_DATE ('2008-1-1,' YYYY-MM-DD'))

5 PARTITION P2 VALUES LESS THAN (TO_DATE ('2009-1-1,' YYYY-MM-DD'))

6 PARTITION PMAX VALUES LESS THAN (MAXVALUE))

The index has been created.

In 10g, Oracle added a new global index partitioning method. Users can choose HASH partitioning method to partition the global index:

SQL > CREATE INDEX IND_PART_INDEX_ID

2 ON T_PART_INDEX (ID) GLOBAL

3 PARTITION BY HASH (ID)

4 PARTITIONS 16

The index has been created.

This kind of global hash partition index is more suitable for data-growing indexes such as ID. Through the HASH algorithm, the incremental index keys can be distributed to multiple partitions to avoid system contention.

At this point, the study on "how to build the ORACLE10g global HASH partition index" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.