partition index and performance

partition index

1. Local Prefixed Partitioned Index

2. Local non-Prefixed Partitioned Index

3. Global Partitioned Index

(Normal Index  is not partitioned..... so it is not a kind of partition index)

1. CREATE INDEX IDX_LPPI_01 ON TAB(COL1,COL2,COL3) LOCAL;  col1 is the partition column

2. CREATE INDEX IDX_LNPPI_01 ON TAB(COL2,COL1,COL3) LOCAL; col1 is the partition column

3. CREATE INDEX IDX_GPI_01 ON (COL2,COL3) GLOBAL PARTITION BY ......;  col1 is the partition column

how to use them?

1.local index is high availability . global index must be rebuild after drop or merge partition.

2.in some case,local non-prefixed partitioned index will cost N times than global index

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12807983/viewspace-715203/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12807983/viewspace-715203/