Assign new or existing database objects to user-defined segments to restrict new objects
to one or more devices, place a table and its index on separate devices, or split an existing
object over multiple devices.
Placing Existing Objects on Segments
sp_placeobject does not remove an object from its allocated segment. However, it causes all further disk allocation for that object to occur on the new segment it specifies.
Creating Clustered Indexes on Segments
The bottom, or leaf level, of a clustered index contains the data. Therefore, a table and its clustered index are on the same segment.