Use Segments to Allocate Database Objects

In a large, multidatabase or multidrive SAP ASE 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.

• Separating Tables, Indexes, and Logs
  Generally, placing a table on one physical device, its nonclustered indexes on a second physical device, and the transaction log on a third physical device improves performance.
• Splitting Tables
  To improve the overall read performance of a table, split a large, heavily used table across devices on separate disk controllers.