Filtered index not used when IS NULL and key lookup with no output

Filtered index not used when IS NULL is used. IS NOT NULL works fine, but IS NULL does a key lookup. Same as this issue but on different version of SQL Serverhttps://connect.microsoft.com/SQLServer/feedback/details/454744/filtered-index-not-used-and-key-lookup-with-no-output

Under Review

Query Processing and Intelligent DatabaseBugs

Company Response

Microsoft

Company Response

Up: 1<=-=Jul 19 2017 11:13AM=-=>Thanks for the feedback. I�ll (re) share the scenario with the engineering team.Joe Sack, Principal PM, Microsoft

0 Comments

You must to comment