• Indexes does not get rebuilt or reorganized automatically. You have to schedule jobs to do this.

    There are a lot of free and great scripts that will do this for you, for example http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html.