| Benefits of
Partioning |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| • | Availability |
||||||||||||||
| – | Partions can
be independently managed |
||||||||||||||
| – | Backup and
restore operations can be done on |
||||||||||||||
| individual
partitions |
|||||||||||||||
| – | Partitions
that are unavailable do not affect queries |
||||||||||||||
| on DML
operations on other paritions that use the |
|||||||||||||||
| same table or
index |
|||||||||||||||
| • | Manageability |
||||||||||||||
| – | A partition
can be moved from one tablespace to |
||||||||||||||
| another |
|||||||||||||||
| – | A partition
can be dropped, truncated, added |
||||||||||||||
| – | A partition
can be divided at user-defined value |
||||||||||||||