Why is a remote, searched DELETE statement not completely evaluated remotely?
You can check elements of the search condition to determine why a remote, searched DELETE statement is not completely evaluated remotely.
Considerations:
- Can the search condition be completely evaluated at the remote data source? If the answer is no, examine the search condition instead.
- Does the search condition reference the target table? Does the data source allow this syntax?
- Does the search condition reference the target table with correlation? Does the data source allow this syntax?