Partitioning

Using partitioning, you can enable the indexes to be sub-divided into smaller manageable segments. This is a logical entity using which you can index records located on multiple servers.

Benefits of Partitioning:

  • Divides data into smaller segments
  • Reduces recovery time
  • Improves performance

You can define partitioning as per your requirement. However, you can use the following examples: