NO STRATEGY NOW (ONLY AT EXECUTION TIME) is a search strategy. In a subquery, the corresponding column values are only known at the execution time for the subquery. The search strategy for the most effective access to the corresponding table for the subquery is only determined when these values are available.
See also: