We currently work with table named tb_tranfers. This table has 40 millions rows and is ~26 GB in size (11 GB Data, 15 GB Indexes)
10 to 15% of the rows are soft deleted rows (DeletedDate Is Not Null). The applicaitons only uses the "DeletedDate Is Null" rows. All queries to this tables will have this clauses to it.
There are 15 on Indexes on this table, The missing index DMV comes us with suggesion to created indexes with DeletedDate column it in.
Would it be helpful to use Filtered Index "where deleteddate is null" on all the 11 non clusetered indexes or could it be beneficial to use deleteddate column as Included Indexes?