ITPub博客

首页 > Linux操作系统 > Linux操作系统 > partition index and performance

partition index and performance

原创 Linux操作系统 作者:dla001 时间:2012-01-28 21:21:16 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 极其低级的错误
请登录后发表评论 登录
全部评论

注册时间:2011-04-28

  • 博文量
    40
  • 访问量
    49049