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.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
