Two nonclusterd index creates any performance issue or not

Jul 10 2013 3:03 AM

hi seniors,

I have a question. I am bit confused. Suppose I have created 5 nonclusterd index in multiple columns. if they contain repeated columns i.e. column c1,c2,c3 present in 3 nonclustered index. due to this is there any performance issue or Not.

Thanks in advance

Answers (2)

Take very much time at the time of deletion by query

store data in table based on id column of another table