Databases Reference
In-Depth Information
The execution plan also shows that in this case two full table scans and two
SORT
UNIQUE
operations are required. The execution plan and statistics for this query are shown in the
following screenshot:
However, in this case, we can translate the
MINUS
operation in a different query using the
ANTI-JOIN
(the
NOT
IN
clause) and
SELECT
DISTINCT
statements, obtaining the query
in step 7. The execution plan and statistics for this are shown in the following screenshot: