1 what 什么是分区
Partitioning enhances the performance, manageability, and availability of a wide variety of applications and helps reduce the total cost of ownership for storing large amounts of data.
Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity.
Oracle provides a rich variety of partitioning strategies and extensions to address every business requirement. Because it is entirely transparent, partitioning can be applied to almost any application without the need for potentially expensive and time consuming application changes.
2 why 为什么要分区
数据库随着数据量的增加,一个表越来越庞大。带来了很多问题。
主要表现为
1 执行sql 语句没有索引,扫描过多无用数据
2 需要一部分数据,由于索引单块读特性,优化器选择全表扫描,读入大量不需要的数据
3 维护数据时,话费大量时间
使用分区表可以避免以上问题
使用分区表还可以
1 均衡IO 分区表每个分区都是一个独立的段,可以放到不同的表空间去
2 增加可用性,一个分区数据出问题不影响其他分区的使用
3 when 什么时候采用分区
老道关于分区表的管理(一) 概念篇
最新推荐文章于 2022-10-24 21:32:16 发布