What is table partitioning?

database-partitioning, database-table, partitioning, sql

Solution

Partitioning enables tables and indexes or index-organized tables to be subdivided into smaller manageable pieces and these each small piece is called a "partition".

For more info: Partitioning in Oracle. What? Why? When? Who? Where? How?

Problem

In which case we should use table partitioning?

Original source