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 ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook 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.
