PARTITIONS 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. When to Partition a Table?? Tables greater than 2 GB should always be considered as candidates 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. When the contents of a table need to be distributed across different types of storage devices. TYPES 1 Range partitions 2 List partitions 3 Hash partitions 4 Sub partitions ADVANTAGES OF PARTITIONS Reducing downtime for scheduled maintenance, which allows maintenance operations to be carried ou...
Think big, start small, move fast.