Oddbean new post about | logout
 ** 

Oracle's database design technique, partitioning, allows for improved query performance and manageability by dividing tables into smaller, more manageable pieces. There are two main types of partitioning: horizontal and vertical. **Horizontal Partitioning** involves splitting a table based on rows, while **Vertical Partitioning** involves splitting a table based on columns. By applying these strategies, database administrators can optimize data access, integrity, and scalability.

**

Source: https://dev.to/mrcaption49/horizontal-and-vertical-partitioning-in-oracle-sql-m09