The MissingIndexAndPageReadsFilter first evaulates if a query performs more than a specified number of page reads, and if it does evaluates if the query execution plan includes MissingIndex hints from the SQL Server optimizer.
Namespace: HuagatiEFProfiler.FiltersAssembly: HuagatiEFProfiler (in HuagatiEFProfiler.dll) Version: 1.33.3996.16092
Syntax
C# |
---|
public class MissingIndexAndPageReadsFilter : PrePlanPostPlanFilter |
Visual Basic |
---|
Public Class MissingIndexAndPageReadsFilter _ Inherits PrePlanPostPlanFilter |
Visual C++ |
---|
public ref class MissingIndexAndPageReadsFilter : public PrePlanPostPlanFilter |
Inheritance Hierarchy
System..::..Object
HuagatiEFProfiler.Filters..::..ProfilerFilter
HuagatiEFProfiler.Filters..::..PrePlanPostPlanFilter
HuagatiEFProfiler.Filters..::..MissingIndexAndPageReadsFilter
HuagatiEFProfiler.Filters..::..ProfilerFilter
HuagatiEFProfiler.Filters..::..PrePlanPostPlanFilter
HuagatiEFProfiler.Filters..::..MissingIndexAndPageReadsFilter