Partitioned Index-Organized Tables (234)

tsinglee發表於2007-11-21

You can partition an index-organized table by RANGE, HASH, or LIST on column
values. The partitioning columns must form a subset of the primary key columns. Just
like ordinary tables, local partitioned (prefixed and non-prefixed) index as well as
global partitioned (prefixed) indexes are supported for partitioned index-organized
tables.

分割槽索引組織表
1. 使用者可以採用 RANGE,HASH,或 LIST 的方式對索引表進行分割槽
2. 分割槽列必須是屬於主鍵列
3. 可在分割槽索引表上建立本地全域性索引

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-983122/,如需轉載,請註明出處,否則將追究法律責任。

相關文章