4

If we create one more non-clustered index on a column which already have one in SQL server, what Would be the effect of that?

Vikant Pundir
  • 65
  • 1
  • 1
  • 5
  • 4
    Yes you can do it. But whats the purpose of it and how are you defining it? Creating two identical indexes on one column is basically a waste of space as you are storing (and maintaining) the same information twice. – Paresh J May 26 '15 at 04:28

1 Answers1

1

Yes, you can do it. But either more index on a column or use of non-clustered index in a table, may be give decrease the performance.

Effect is judge at run-time based on your search condition.

http://logicalread.solarwinds.com/duplicate-indexes-and-sql-server-performance-nh01/#.VWP8JUaWvQA

SQL Server: multiple index for the same columns performance

Create more than one non clustered index on same column in SQL Server

SQL Server creating multiple nonclustered indexes for one column vs having multiple columns in just one index

Community
  • 1
  • 1
Ajay2707
  • 5,690
  • 6
  • 40
  • 58