当表的大小达到GB级别且持续增长,或对于OLTP系统,表的记录超过1000万时,都应考虑对表进行分区。
Oracle官网的2个建议如下:
Tables greater than 2GB should always be considered for partitioning.
Tables containing historical data, in which new data is added into the newest partition. A typical example is a historical table where only the current month's data is updatable and the other 11 months are read only.