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.