Segment Usage in SAP ASE

When you add a new device to a database, SAP ASE places the new device in a default pool of space (the database’s default and system segments).

This increases the total amount of space available to the database, but it does not determine which objects occupy that new space. Any table or index may grow to fill the entire pool of space, leaving critical tables with no room for expansion. Several heavily used tables and indexes may be placed on a single physical device in the default pool of space, resulting in poor I/O performance.

When you create an object on a segment, the object can use all the database devices that are available in the segment, but no other devices. You can use segments to control the space that is available to individual objects.

The following sections describe how to use segments to control disk space usage and to improve performance.