Error 1530

Severity Level 16
Message Text

CREATE INDEX with DROP_EXISTING was aborted because a row was out of order. Most significant offending primary key is '%S_KEY'. Explicitly drop and create the index instead.

Explanation

This error occurs when you try to create an index using the DROP_EXISTING clause of the CREATE INDEX statement on a column or columns containing data that is not in sorted order. When this error occurs, no index is created.

The DROP_EXISTING clause speeds creation of an index when the data in the table is already in sorted order. The space required to build a clustered index is less when the DROP_EXISTING clause is used.

The DROP_EXISTING clause speeds index creation only for clustered indexes or unique nonclustered indexes. Creating a nonunique, nonclustered index with the DROP_EXISTING clause may succeed, but there is no improvement in performance.

Action

Use either of these strategies:

You can also use the SORTED_DATA_REORG clause, which physically reorganizes the data.

See Also
Errors 1000 - 1999 CREATE INDEX

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.