• as for reubilding indexes, sql server does not do this automatically at some point?

    What are the reasons for having to rebuilding indexes? inserts, deletes?