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.
Author |
Topic |
sunnyh
Starting Member
3 Posts |
Posted - 2014-02-05 : 07:38:44
|
Hi,We have two non cluster indexes on the same column for a table. Could anyone please let me know will it impact negatively on table like performance etc. ? |
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-02-05 : 19:38:33
|
Are the indexes identical? Are the two indexes only on that one column or are other columns part of each index? Are there include columns used in the indexes?===============================================================================There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber (1894-1961) |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2014-02-05 : 20:00:32
|
quote: Originally posted by sunnyh Hi,We have two non cluster indexes on the same column for a table. Could anyone please let me know will it impact negatively on table like performance etc. ?
Yes it will have a negative impact on performance. |
|
|
sunnyh
Starting Member
3 Posts |
Posted - 2014-02-06 : 00:39:04
|
Hi Bustaz Kool,Yes they both are identical and both indexes are only on that single column.Hi Lamprey,Thanks for your response. |
|
|
Avinaash.S786
Starting Member
9 Posts |
|
|
|
|