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