Identifying Missing Indexes
When developing an index design for your database and applications, you should make sure you create appropriate indexes for the various queries that will be executed against your tables. However, it can be quite a chore to identify all the queries you may need to create indexes for. Fortunately, SQL Server 2012 provides a couple of tools to help you identify any indexes you may need in your database: The Database Engine Tuning Advisor and the missing index dynamic management objects.
Get Microsoft® SQL Server 2012 Unleashed 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.
