What are the disadvantages to Indexes in database tables? : <p>Is there any reason I shouldn't create an index for every one of my database tables, as a means of increasing performance? It would seem there must be some reason(s) else all tables would automatically have one by default.</p>

<p>I use MS SQL Server 2016.</p>
