The complete syntax of the create index command is:
create [unique] [clustered | nonclustered]
index index_name
on [[database.]owner.]table_name (column_name
[, column_name]...)
[with {{fillfactor | max_rows_per_page} = x,
ignore_dup_key, sorted_data,
[ignore_dup_row | allow_dup_row]}]
[on segment_name] [with consumers = x]
The following sections explain the various options to this command.
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.
