O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to find missing indexes

By now, we hope that you have understood the requirement of the index in performance. While developing a database table, initially it is not always possible for us to predict the right column as an index. So, as per our prediction, we used to generate an index that might be helpful; sometimes it would not even be used, and sometimes, we would need other indexes as well, apart from the initial index we had created. So, now the question arises as to how to find the indexes that are not even generated. How can we predict which indexes are missing and which we need to create?

Generally, whenever any query gets executed, SQL Server query optimizer finds the best index for the execution, and if it doesn't find it, the optimizer ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required