In this chapter, you will learn about:
• Optimizing databases with indexes
• Optimizing indexes
• 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.
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 ...