Why was partitioning by status chosen, given that historically there are more dismissed employees than active ones?

Partitioning by status (for example, active and terminated employees) can be chosen to optimize queries and data management, even though there are more terminated employees. This is because active employees are data that are accessed more frequently in operational processes, and their partition will be more 'hot' and often used.

Advantages of this approach:

• Quick access to current data (active employees) without the need to scan large volumes of historical data.
• Simplification of data archiving and cleanup: a partition with terminated employees can be archived or cleaned without affecting active ones.
• Load separation and storage optimization.

Thus, the choice of partitioning by status is driven not only by the number of records but also by the nature of data usage and performance requirements.