IN (Include Delayed): response time-based optimizer
- Each iteration generates a complete alternative plan
- Chooses a very long delay duration (relative to response time) to postpone any access to the delayed data.
- Chooses a plan with the greatest benefit (potential improvement in response time) whose risk (duration of the optimization step) can be overlapped with the expected delay duration.