001、Partitioning addresses key issues in supporting very large tables and indexes by decomposing them into smaller and more manageable pieces calledpartitions, which are entirely transparent to an application.
    分割槽技術對應用完全透明。

002、SQL queries and Data Manipulation Language (DML) statements do not need to be modified to access partitioned tables.
    查詢和DML語句訪問分割槽表的時候不需要做修改。

003、However, after partitions are defined, Data Definition Language (DDL) statements can access and manipulate individual partitions rather than entire tables or indexes. This is how partitioning can simplify the manageability of large database objects.
    DDL語句可以直接訪問和操作單個分割槽而不是整個表或索引。這就是分割槽技術簡化大資料庫物件管理的實現。

004、Each partition of a table or index must have the same logical attributes, such as column names, data types, and constraints, but each partition can have separate physical attributes, such as compression enabled or disabled, physical storage settings, and tablespaces.
    每個表或索引的分割槽必須擁有相同的邏輯屬性，例如列名，資料型別，約束，不過每個分割槽可以擁有各自的物理屬性，例如是否壓縮，物理儲存設定，表空間等。

005、Partitioning is useful for many different types of applications, particularly applications that manage large volumes of data. OLTP systems often benefit from improvements in manageability and availability, while data warehousing systems benefit from performance and manageability.
    分割槽技術對需要管理大量資料的應用很有用。OLTP系統從管理性和可用性獲益，資料倉儲則從效能和管理性獲益。

006、分割槽的好處：
    It enables data management operations such as data loads, index creation and rebuilding, and backup and recovery at the partition level, rather than on the entire table. This results in significantly reduced times for these operations.
    使得資料管理操作可以在分割槽水平實現，而不用在整個表水平實現。例如資料載入，索引建立和重建，備份和恢復。這意味著可以顯著減少這些操作的時間。

    It improves query performance. Often the results of a query can be achieved by accessing a subset of partitions, rather than the entire table. For some queries, this technique (called partition pruning) can provide order-of-magnitude gains in performance.
    分割槽改善了查詢效能。很多情況下一個完成一個查詢只要查詢幾個分割槽即可，而不是整個表。對於某些查詢在效能上可以達到數量級的飛躍。

It significantly reduces the impact of scheduled downtime for maintenance operations.

Partition independence for partition maintenance operations lets you perform concurrent maintenance operations on different partitions of the same table or index. You can also run concurrent SELECT and DML operations against partitions that are unaffected by maintenance operations.

    顯著減少維護操作的預定停機時間。對於分割槽維護操作來說，分割槽獨立性使得你得以在表或索引的不同分割槽執行並行維護操作。你同樣可以對不受維護操作影響的分割槽執行並行查詢和DML操作。

    It increases the availability of mission-critical databases if critical tables and indexes are divided into partitions to reduce the maintenance windows, recovery times, and impact of failures.
    分割槽增加了執行關鍵任務的資料庫的可用性。如果將關鍵表和索引分割槽，可以縮短維護視窗，減少恢復時間，以及減少資料庫故障帶來的影響。

    Parallel execution provides specific advantages to optimize resource utilization, and minimize execution time. Parallel execution against partitioned objects is key for scalability in a clustered environment. Parallel execution is supported for queries and for DML and DDL.
    並行執行為資源利用提供了明顯的優勢，同時最小化執行時間。在一個叢集環境中針對分割槽物件的並行執行是可擴充套件性的關鍵。並行執行支援查詢、DML和DDL。

007、Partitioning enables faster data access within an Oracle database. Whether a database has 10 GB or 10 TB of data, partitioning can improve data access by orders of magnitude. Partitioning can be implemented without requiring any modifications to your applications. For example, you could convert a nonpartitioned table to a partitioned table without needing to modify any of the SELECT statements or DML statements that access that table. You do not need to rewrite your application code to take advantage of partitioning.
    在Oracle資料庫中分割槽使得資料訪問更加快速。無論一個資料庫擁有10GB還是10TB的資料，分割槽技術都能以數量級的形式來提高資料訪問速度。實現分割槽無需對應用做任何修改。例如，你可以將一張非分割槽錶轉換成分割槽表，但你訪問這張表的select語句和DML語句不用做任何修改。不用重寫你的程式碼你就能獲得分割槽帶來的優勢。

Introduction to Partitioning

相關文章