CHAPTER 7 Optimizing Databases
In this chapter, you will learn about:
• Optimizing databases with indexes
• Optimizing indexes
• Statistics
• Full-text catalogs and indexes
• Database Engine Tuning Advisor
• Index maintenance
• Database Console Command (DBCC)
• Use of filegroups
The art of being wise is the art of knowing what to overlook. —William James |
Whenever you're tasked with optimizing a database, looking at the indexes is typically where you'll find you can get the best gains. Knowing when to use a clustered index, when a nonclustered index will work, and how to maintain the indexes can help you significantly improve performance of many databases.
Many tools are available to help us optimize a database. Knowing which tools to use for ...
Get MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) 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.
