Create Clustered Indexes on Segments

The create index command allows you to create the index on a specified segment.

Since the leaf level of a clustered index and its data pages are the same by definition, creating a clustered index and using the on segment_name extension moves a table from the device on which it was created to the named segment.

See a system administrator or the database owner before creating tables or indexes on segments; certain segments may be reserved for performance reasons.