Chapter 12: Creating Indexes on Tables
Specifying index options
The index
options ignore_dup_key, ignore_dup_row,
and allow_dup_row control what
happens when a duplicate key or duplicate row is created with insert or update. Table 12-2 shows which option
to use, based on the type of index.
Table 12-2: Index options
Index type
|
Options
|
|---|
Clustered
|
ignore_dup_row | allow_dup_row
|
Unique clustered
|
ignore_dup_key
|
Nonclustered
|
None
|
Unique nonclustered
|
ignore_dup_key
|
Unique nonclustered
|
ignore_dup_row
|
|
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF 