Show TOC

NO STRATEGY NOW (ONLY AT EXECUTION TIME)Locate this document in the navigation structure


NO STRATEGY NOW (ONLY AT EXECUTION TIME) is a search strategy of the SQL optimizer.

When Can the System Use This Strategy?

If the column values of a subquery are not known until the subquery is executed, then the SQL optimizer does not choose the most effective search strategy for accessing the table until these values are available.

How Does the System Access the Data?

The system chooses the actual strategy at runtime.