Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Administration  Does duplicate records affect Index Performance?

Author  Topic  sura Starting Member 10 Posts Posted - 2012-09-19 : 05:04:40 Hello All We are trying to create Non Unique / Non Cluster Index for a table. For some reasons if the Index columns get duplicate while load the data into the table in any of the way does it will affect the load performance? What all are the points to be considered before create an index to a table? Any suggestions are welcome. Thanks in advance Sure