The complete syntax of the create index command is documented in the Reference Manual.
The following sections explain the various options to this command. For information about creating and managing index partitions, including use of the index_partition_clause, see Chapter 10, “Partitioning Tables and Indexes.”
The on segment _name extension
to create index allows you to place your index
on a segment that points to a specific database device or a collection
of database devices. Before creating an index on a segment, see a
System Administrator or the Database Owner for a list of segments
that you can use. Certain segments may already be allocated to specific
tables or indexes for performance reasons or for other considerations.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
