oracle为什么要分区（Why should the Oracle partition）.doc

oracle为什么要分区（Why should the Oracle partition） On the partitioning function in the Oracle Database 10g The Oracle partitioning capabilities can improve manageability, performance, and availability of many applications. By partitioning functions, you can further subdivide tables, indexes, and index organized tables into segments, enabling you to manage and access these database objects more precisely. Oracle provides a wide variety of partitioning schemes to meet each business requirement. Also, since the partition is completely transparent in the SQL statement, this function can be applied to almost any application. Advantages of partitioning functionality Partitioning capabilities bring great benefits to a wide variety of applications by improving manageability, performance, and availability. Typically, partitioning can greatly improve the performance of certain queries and maintenance operations. In addition, partitioning can greatly simplify common management tasks. Through partitioning, database designers and administrators can solve some of the problems associated with cutting-edge applications. Partitioning is a critical tool for building gigabytes of data systems or ultra high availability systems. Basic knowledge of partitioning functions Partitioning functions can further subdivide a table, index, or index table into segments. The segments of these database objects are called partitions. Each partition has its own name, and you can also select your own storage features. From the point of view of a database administrator, a partitioned object has multiple segments that can be collectively managed or managed separately. This allows the database administrator to have considerable flexibility in managing objects after partitioning. However, from the applications point of view, the partitioned table is exactly the same as the non partitioned table, without any modifications when accessing the partitioned table using the SQL DML command. The partition of the table