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?
vd8tlhqk1#
Yes, you can do it. But either more indexes on a column or the use of a non-clustered index in a table may decrease the performance.
The effect is judged at runtime 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
1条答案
按热度按时间vd8tlhqk1#
Yes, you can do it. But either more indexes on a column or the use of a non-clustered index in a table may decrease the performance.
The effect is judged at runtime 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