First of all Good morning !
Today I got one question regarding indexes and tables. Actually I am not facing problem regarding this but due to curiosity I want to post !!
Now come to the point,
Suppose I create 20 indexes ( obviously non-clustered) on one table (which have id,name,username,password). It will work fine.
Now the point is if I modify my table as (id,name,username,password,status,varification_code) and indexes are remains 20. Will it effect the performance ?
And what will be if indexes increase or decreases and table remains same ?
And what will be if indexes increase or decreases and table modified ?