What is recommended for partitioning in SailPoint?

The recommendation to use fewer larger partitions in SailPoint IdentityIQ is based on the desire to balance performance with manageability. Larger partitions tend to reduce the overhead that comes with managing multiple partitions, which can lead to simpler system administration. Fewer partitions can also minimize the complexity of the data model, making it easier for users to navigate and for system administrators to understand the overall structure and flow of identity governance processes.

Additionally, larger partitions can help improve query performance since they reduce the number of partitions the system needs to traverse during operations like policies enforcement, reporting, or compliance checks. This can lead to improved stability and performance in IdentityIQ, especially in environments with high transaction volumes or numerous identities and resources to manage.

While smaller partitions might appear to offer more granularity, they can lead to increased resource consumption and more complicated data management tasks, which can impact system efficiency and performance. Therefore, utilizing fewer larger partitions strikes a balance that simplifies management while ensuring that the identity governance processes remain efficient and effective.