Miscellaneous Information about Creating Indexes on Partitioned Tables
You can create bitmap indexes on partitioned tables, with the restriction that the
bitmap indexes must be local to the partitioned table. They cannot be global indexes.
Global indexes can be unique. Local indexes can only be unique if the partitioning key
is a part of the index key.
可在分割槽表上建立點陣圖索引,但必須是Local型別
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-1002305/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 關於分割槽表和分割槽索引(About Partitioned Tables and Indexes)索引Index
- Bitmap Indexes on Partitioned Tables (225)Index
- Creating Compressed Tables and IndexesIndex
- Overview of Partitioned IndexesViewIndex
- Local Partitioned IndexesIndex
- Oracle Partitioned TablesOracle
- Global Range Partitioned IndexesIndex
- Global Hash Partitioned IndexesIndex
- Maintenance of Global Partitioned IndexesAINaNIndex
- Partitioned Tables (165)
- Oracle - Tables/IndexesOracleIndex
- Partitioned Indexes on Composite PartitionsIndex
- Create Reference-Partitioned Tables
- [20130812]12c Partial Indexes For Partitioned Tables Part I.txtIndex
- [20130812]12c Partial Indexes For Partitioned Tables Part II.txtIndex
- Using Partitioned Indexes in OLTP ApplicationsIndexAPP
- Creating Secondary IndexesIndex
- Partitioned Index-Organized Tables (234)IndexZed
- Getting More Information about PartitionsORM
- Row Movement Common Questions and Problems on Partitioned Tables
- Allocation of Temporary Segments for Temporary Tables and Indexes (28)Index
- FAQ: Row Movement Common Questions and Problems on Partitioned Tables
- Using Partitioned Indexes in Data Warehousing and DSS ApplicationsIndexAPP
- Validating Tables, Indexes, Clusters, and Materialized ViewsIndexZedView
- Bitmap Indexes on Index-Organized Tables (232)IndexZed
- Using SQL Script Get Information about ASMSQLORMASM
- Viewing Information About the SGA (115)ViewORM
- Secondary Indexes on Index-Organized Tables (231)IndexZed
- Use the following approach to create tables with constraints and indexes:APPAIIndex
- Oracle 19c Concepts(03):Indexes and Index-Organized TablesOracleIndexZed
- Overhead Cost Controlling – Information System, iViews tablesORMView
- 【OCP最新題庫解析(052)--題3】Which two are true about external tables?
- B-tree Indexes on UROWID Columns for Heap- and Index-Organized Tables (235)IndexZed
- MySQL 8.0 Reference Manual(讀書筆記85節-- InnoDB INFORMATION_SCHEMA Tables(1))MySql筆記ORM
- MySQL 8.0 Reference Manual(讀書筆記86節-- InnoDB INFORMATION_SCHEMA Tables(2))MySql筆記ORM
- android wear-Showing Information in Watch Faces and Creating InteractiveWatch Faces, Providing ConfiAndroidORM
- Convert Range-Partitioned Table To Interval-Range-Partitioned Table
- partitioned by timestamp datatype