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
Org.sonar.api.batch.fs Interface InputFileFilter accept conditions SonarQube Server / Community Build	0	417	June 18, 2018
SQL query that uses not in with a subquery New rules / language support tsql	1	1535	August 29, 2018
Exclude TAG in filter query? Suggest new features tags	3	908	November 15, 2019
T-SQL Plugin - rule for EXISTS / NOT EXISTS New rules / language support tsql	1	1153	August 29, 2018
New code is not fully detected when using sonar.inclusions filter SonarQube Server / Community Build csharp , q_gate , new_code	3	1039	November 18, 2020