Designing and manage partitioning of Data
- Details
- Category: Performance
- Published: Thursday, 28 April 2016 22:06
- Written by Super User
- Hits: 1099
Is your table data getting to large to manage ? Does queries take to long to execute ? If you answer these two question with YES then you should consider to partition your large tables.
When data becomes to large for your system the solution is often to buy bigger hardware or assign more cpu and memory resources to the machine to solve the problem when the best, cheapest and most effective solution is to partition the data into more manageable parts.
Modern databases have and offer a feature called table partitioning which reduces query execution times and makes the data more manageable.
What is Table Partitioning.
Table partitioning is a data organization scheme to divide large quantity of data into multiple data storages (data partitions). These data storage objects can be in different table spaces, in the same table space, on same or different storage paths/disks or a combination of these. The whole purpose of table partitioning is to divide the table data into smaller and more manageable data units, shorten reorganization needs/ -time and speed up inserts/updates/deletes and queries execution time that on regular tables becomes slower as the data in the table grows.