In the last post
you saw that the missing index feature does not gather statistics for more than 500 missing index groups.
This time I am going to reveal another limitation which is not even documented
– the missing index feature does not recommend missing indexes for trivial queries.SQL Server has to create an execution plan before executing a query because it has to evaluate the different available physical iterators depending on the cardinality estimation, supportive indexes, available hardware resources and instance settings to find a good enough plan.
Query optimization is a CPU, memory and especially a time expensive process. Therefore Microsoft implemented several rules and thresholds to avoid situations where it takes too long to find a query execution plan. SQL Server even can skip the