Filter operator in SQL Server execution plan

The Filter operator in a SQL Server execution plan is a logical operator that processes rows from its input and evaluates a predicate (condition) on each row. It works on row level filtering. It evaluate each row to determine whether it meets the condition specified in the query and only pass the row that meets this condition to the next operator in in the plan.

Icon of Filter Operator

Let’s see the example.

See the below query here we are using the where clause to filter the records.

select * from Sales.SalesOrderHeader where ShipDate>'2013-07-17'

See the execution plan