When using a DBMS without an optimizer, the formulation of a query can make a difference in the speed with which the query is executed.

Question

Quizplus · Accepted Answer

Without an optimizer, the DBMS does not automatically optimize the execution plan for a query. Therefore, how the query is formulated can significantly impact the execution speed, as the system will execute the query exactly as it is written without making any adjustments for efficiency.

When Using a DBMS Without an Optimizer, the Formulation of a Query