Chapter 9. Managing and Optimizing SQL Server 2005 Indexes
SQL Server 2005 uses indexes to structure and optimize access to data found within the tables of a database. Index design, maintenance, and optimization are key factors that contribute to how well a database performs. Although the lack of indexes or the use of poorly designed indexes, along with inadequate maintenance, can lead to performance degradation, well-designed and maintained indexes can significantly improve the overall performance of a database by reducing the cost associated with locating data.
When you are performing management and administrative tasks on indexes, it is important to understand the different options and powerful tools that help make indexing management and ...
Get Microsoft® SQL Server 2005 Management and Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
