Segments
Go Up to Supported Objects
Segments are a mechanism for placing tables and indexes on specific logical partitions. You create segments on one or more fragments of a database. You can map segments to specific database fragments, which in turn reside on specific hard disks; and, mapping segments lets you increase i/o throughput by placing intensively used tables and indexes on different physical devices. You can allocate tables and indexes to segments by including placement statements at the end of CREATE TABLE or CREATE INDEX statements.
Creating and editing
DBMS platform availability and object actions/operations supported
The table below lists the platforms on which this object type is available. It also lists the object actions available against objects of this type. For an introduction to object actions and details on usage of specific actions, see Object actions.
| SYB ASE | |
|---|---|
|
✓ | |
|
✓ | |
|
✓ | |
|
✓ |