When it comes to indexing, Microsoft has two tools built into SQL Server that can be used to help identify indexes that can improve database performance. These are the missing index dynamic management objects (DMOs) and the Database Engine Tuning Advisor (DTA). Both tools are useful to assist with indexing databases and can provide valuable input when working on tuning a database.
This chapter explains both indexing tools. The chapter begins by explaining what they are and the capabilities they provide. Then it walks you through how the tools can be used to provide assistance with indexing. Throughout the chapter, you ...