When to Partition a Table
Here are some suggestions for when to partition a table:
■ 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.[@more@]
■ 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.[@more@]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10599713/viewspace-1001830/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- partition table and partition indexIndex
- 拆分Table 為Partition Table
- partition table test
- partition table(1)
- partition table(2)
- [Oracle] Partition table exchange Heap tableOracle
- Oracle 普通table 轉換為partition tableOracle
- create a partition table using a exsit table
- 分割槽表PARTITION table
- partition table update partition-key result in changing tablespace
- db2 partition table testDB2
- Interval Partition table 11G
- Oracle分割槽表(Partition Table)Oracle
- How to partition a non-partitioned table
- 分割槽表PARTITION table(轉)
- partition table中truncate應用
- mysql partition table use to_days bugMySql
- 關於partition table import的問題Import
- doesn't contain a valid partition tableAI
- add hash partition , default tablespace for patitioned table
- 【DB】Direct Path EXP Corrupts The Dump If An Empty Table Partition Exists
- Applying “Incremental Statistic” for Oracle Big Partition TableAPPREMOracle
- Data Warehouse Guide閱讀筆記（七）：partition tableGUIIDE筆記
- ext4 lvreduce報錯superblock or the partition table is likely to be corruptVRBloC
- TiDB 原始碼閱讀系列文章（二十）Table PartitionTiDB原始碼
- 今天測試了一下update partition table的part key
- best practice of rebuild your partition table local index online by using: "update indexes"RebuildIndex
- PARTITION partition01
- PARTITION partition02
- PARTITION partition04
- mysqldump匯出報錯"mysqldump: Error 2013 ... during query when dumping tableMySqlError
- Pruning、Reference Partition、Exchange Partition
- partition timestamp(0) not use partition
- 教你解決ghost win10開機出現invalid partition table的方法Win10
- [20191203]enq: ZA - add std audit table partition.txtENQ
- PARTITION SPILT
- hive partitionHive
- over (partition by)