I'm optimizing a query on SQL 2000. The query joins a single table to itself 5 times to get various MAX(values).
When I add a large covering clustered (or non-clustered index) to the table to help the query, performance suffers greatly. This is a select statement only.
Why would a large index negatively impact read performance ?