First introduced in SQL Server ... indexes have a tree structure on disk (called a B-tree) that has a key value, which allows the database engine to quickly retrieve the row needed using a key.

Do my end users care that it's slowing my SQL Server down? Before we can answer the follow-up question of do my users care, we need to first understand why having too many indexes is a bad thing.

See performance gains by using indexed views in SQL ... t do anything until you query it. In SQL Server 2000 and 2005, you have the ability to add indexes to views. But, if a view is just a ...