Describe désert/Oracle/Partition here.
2.1.3.1 When to Partition a Table
There are certain situations when you would want to partition a table. Here are some suggestions for situations when you should consider partitioning a table:
- Tables that are greater than 2 GB.
These tables should always be considered as candidates for partitioning.
- Tables that contain 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.
- Tables whose contents must be distributed across different types of storage
2.1.3.2 When to Partition an Index
There are certain situations when you would want to partition an index.
Here are some suggestions for when to consider partitioning an index:
- • Avoid index maintenance when data is removed.
- • Perform maintenance on parts of the data without invalidating the entire index.
- • Reduce the effect of index skew caused by an index on a column with a monotonically increasing value.