Partitioned Index-Organized Tables (234)
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. 可在分割槽索引表上建立本地全域性索引
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-983122/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Partitioned TablesOracle
- Partitioned Tables (165)
- Create Reference-Partitioned Tables
- Overview of Index-Organized Tables (227)ViewIndexZed
- Benefits of Index-Organized Tables (229)IndexZed
- The differences between index-organized tables and ordinary tables (228)IndexZed
- Bitmap Indexes on Partitioned Tables (225)Index
- Bitmap Indexes on Index-Organized Tables (232)IndexZed
- Row Movement Common Questions and Problems on Partitioned Tables
- Index-Organized Tables with Row Overflow Area (230)IndexZed
- Secondary Indexes on Index-Organized Tables (231)IndexZed
- FAQ: Row Movement Common Questions and Problems on Partitioned Tables
- Miscellaneous Information about Creating Indexes on Partitioned TablesORMIndex
- Oracle 19c Concepts(03):Indexes and Index-Organized TablesOracleIndexZed
- 關於分割槽表和分割槽索引(About Partitioned Tables and Indexes)索引Index
- B-tree Indexes on UROWID Columns for Heap- and Index-Organized Tables (235)IndexZed
- 高效的SQL(Index-Organized Tables優化精確查詢和範圍查詢)SQLIndexZed優化
- [20130812]12c Partial Indexes For Partitioned Tables Part I.txtIndex
- [20130812]12c Partial Indexes For Partitioned Tables Part II.txtIndex
- 234
- Overview of Partitioned IndexesViewIndex
- Local Partitioned IndexesIndex
- Convert Range-Partitioned Table To Interval-Range-Partitioned Table
- partitioned by timestamp datatype
- Global Range Partitioned IndexesIndex
- Global Hash Partitioned IndexesIndex
- Maintenance of Global Partitioned IndexesAINaNIndex
- dba_tables,dba_all_tables,user_tables,all_tables有什麼區別
- Oracle Index-organized table (IOT)概述OracleIndexZed
- Partitioned Indexes on Composite PartitionsIndex
- Index-Organized Table Applications (236)IndexZedAPP
- Oracle TablesOracle
- ABC_234_ex sol
- Oracle Partitioned Table:exchange的利用Oracle
- How to partition a non-partitioned table
- Oracle Externale TablesOracle
- Oracle - Tables/IndexesOracleIndex
- Oracle X$TablesOracle