Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

An index already exists for table <Tablename> with the columns <Columnnames>. (Visual Database Tools)

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.

For more information, see Indexes and Creating Indexes (Database Engine).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft