An index already exists for table '<0s>' with the columns '<1s>'.

Message Text

An index already exists for table '<0s>' with the columns '<1s>'.

Explanation

Oracle only allows one index for each ordered set of columns.

Action

As a rule, you should create an index only if the data in the selected columns will be queried frequently. Indexes take up disk space and can slow the adding, deleting, and updating of rows.

In most cases, the benefits of indexes will far outweigh the performance overhead, but if your application updates data very frequently, or if you have disk space constraints, you might also want to limit the number of indexes.

See Also
ALTER TABLE How to create an index using the Create Index Wizard (Enterprise Manager)
Creating an Index How to create an index when creating a table (Enterprise Manager)
CREATE INDEX Index Object
CREATE TABLE Indexes
Creating SQL Server Indexes Modifying Column Properties
How to create an index on an existing table (Enterprise Manager) Table Indexes

 

  


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