Disk-storage performance factors

Hardware characteristics, such as disk-storage configuration, can strongly influence the performance of your system.

Performance can be affected by one or more of the following aspects of disk-storage configuration:
  • Division of storage

    How well you divide a limited amount of storage between indexes and data and among table spaces determines to a large degree how the system will perform in different situations.

  • Distribution of disk I/O

    How well you balance the demand for disk I/O across several devices and controllers can affect the speed with which the database manager is able to retrieve data from disk.

  • Disk subsystem core performance metrics

    The number of disk operations per second, or the capacity in megabytes transferred per second, has a very strong impact on the performance of the overall system.