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:

  i. Tables that are greater than 2 GB.
These tables should always be considered as candidates for partitioning.

  i. 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.

  i. 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:
 i. • Avoid index maintenance when data is removed.
 i. • Perform maintenance on parts of the data without invalidating the entire index.
 i. • Reduce the effect of index skew caused by an index on a column with a monotonically increasing value.