When a filtered index is created, the columns that are used should be part of the included columns. [image] Filtered Indexes: Just Add Includes - Brent Ozar Unlimited® I found a quirky thing recently While playing with filtered indexes, I noticed something odd. By ‘playing with’ I mean …

New SQL Rule - filter index creation without filter columns in include - performance

pregress (Preben Huybrechts) December 24, 2021, 8:04am 1

When a filtered index is created, the columns that are used should be part of the included columns.

Topic		Replies	Views
TSQL plug-in: filtering message specific issues SonarQube Server / Community Build	8	1388	July 25, 2018
New SQL Rule - table variables are used instead of temp tables - performance New rules / language support tsql	0	1702	December 24, 2021
T-SQL Plugin - New rule for blocking issues in TempDb related to Select * Into # New rules / language support tsql	2	988	August 30, 2018
Rules for PL/SQL that need database properties SonarQube Server / Community Build plsql , rules	3	573	July 24, 2020
Custom rules for SQL New rules / language support tsql	8	2440	August 26, 2021