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 |
|
|
|
|
|
two non-cluster indexes on same coulumn