See Also: Main_Page - Database Administration - Database Design
How SQL Server Indexes Work
Types of Indexes in SQL Server
- Included Columns - starting with SQL Server 2005, you can add fields to indexes with a smaller performance hit.
- Indexed Views - how to build indexes on top of views for more speed.
- XML Indexes Overview - how to index XML documents and fragments.
- XML Index Rules - some additional considerations and requirements for XML indexes.
Best Practices on How to Design Database Indexes
Maintaining Indexes for Top Performance
Indexes need regular maintenance in order to perform well.
Other Index-Related Articles at SQLServerPedia