Partitioned Tables (165)
Partitioned tables allow your data to be broken down into smaller, more manageable
pieces called partitions, or even subpartitions. Indexes can be partitioned in similar
fashion. Each partition can be managed individually, and can operate independently
of the other partitions, thus providing a structure that can be better tuned for
availability and performance.
分割槽表
1. 使用者可以使用分割槽表將資料劃分為更小 , 更易管理的單位 , 這種單位被稱為分割槽.
2. 分割槽還可以被繼續劃分為子分割槽 .
3. 索引也可以採取類似方式進行分割槽.
4. 每個分割槽可以獨立操作 , 獨立管理 , 有利於提高系統的可用性和效能.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-981302/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle Partitioned TablesOracle
- Create Reference-Partitioned Tables
- Bitmap Indexes on Partitioned Tables (225)Index
- Partitioned Index-Organized Tables (234)IndexZed
- Row Movement Common Questions and Problems on Partitioned Tables
- FAQ: Row Movement Common Questions and Problems on Partitioned Tables
- Miscellaneous Information about Creating Indexes on Partitioned TablesORMIndex
- 關於分割槽表和分割槽索引(About Partitioned Tables and Indexes)索引Index
- [20130812]12c Partial Indexes For Partitioned Tables Part I.txtIndex
- [20130812]12c Partial Indexes For Partitioned Tables Part II.txtIndex
- 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有什麼區別
- Partitioned Indexes on Composite PartitionsIndex
- ARC165F題解
- Oracle TablesOracle
- Oracle Partitioned Table:exchange的利用Oracle
- How to partition a non-partitioned table
- Oracle Externale TablesOracle
- Oracle - Tables/IndexesOracleIndex
- Oracle X$TablesOracle
- Oracle X$ TablesOracle
- Edit SAP tables
- Using Partitioned Indexes in OLTP ApplicationsIndexAPP
- MySQL 5.5 LOCK TABLES 和 UNLOCK TABLES 語句介紹MySql
- The differences between index-organized tables and ordinary tables (228)IndexZed
- Leetcode 165 Compare Version NumbersLeetCode
- Profitability Analysis – General tables
- 【oracle】user_tablesOracle
- Views and Base Tables (243)View
- Restrictions on Analyzing TablesREST
- Overview of Tables (154)View
- PostgreSQL DBA(165) - pgAdmin(Create Function選項)SQLFunction