More than one indexes on same column in SQL server

sql-server non-clustered-index
Vikant Pundir picture Vikant Pundir · May 26, 2015 · Viewed 7.7k times · Source

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?

Answer

Ajay2707 picture Ajay2707 · May 26, 2015

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

Related questions

What do Clustered and Non clustered index actually mean?

I have a limited exposure to DB and have only used DB as an application programmer. I want to know about Clustered and Non clustered indexes. I googled and what I found was : A clustered index is a special type …

Read More
What are the differences between a clustered and a non-clustered index?

What are the differences between a clustered and a non-clustered index?

Read More
Difference between clustered and nonclustered index

I need to add proper index to my tables and need some help. I'm confused and need to clarify a few points: Should I use index for non-int columns? Why/why not I've read a lot about clustered and non-clustered …

Read More