In a large, multidatabase or multidrive Adaptive Server environment, you can enhance system performance by paying careful attention to the allocation of space to databases and the placement of database objects on physical devices. Ideally, each database has exclusive use of database devices, that is, it does not share a physical disk with another database. In most cases, you can improve performance by placing heavily used database objects on dedicated physical disks or by “splitting” large tables across several physical disks.
The following sections describe these ways to improve performance. Chapter 1, “Controlling Physical Data Placement,” in Performance and Tuning Series: Physical Database Tuning offers more information about how segments can improve performance.
