Horizontal table partitioning allows Database Administrators (DBAs) to design a physical database layout that aligns storage with specific data values or ranges. The physical separation of data into partitions can improve performance, maintenance, and data availability. Your initial migration to a partitioned table architecture can be performed without moving any data, but changing an existing partition scheme requires a dump and load. For this reason, it is wise to plan your partitioning scheme well. The best table partition design depends on many factors specific to your data and database.
