Benefits of using NOEXPAND hints (Indexed Views)https://sqlperformance.com/2015/12/sql-performance/noexpand-hintshttps://sqlperformance.com/2014/01/sql-plan/indexed-views-and-statistics