Well-constructed indexes can greatly improve read performance in SQL server, but they can be costly to maintain.   There’s the obvious cost of additional time for your periodic index maintenance (rebuilds, reorganization and updating statistics) ...read more