Databases Reference
In-Depth Information
The execution plan and statistics for this query are shown in the following screenshot:
In step 5, we rewrite the previous query using the
NOT
IN
operator; in the next screenshot we
can see the results of this execution: