Question

if the outer query fetches n rows the independent subquery inside it would run ___ time(s).

Answer 1

tubery


hope it helps you

Answer 2

The query will run 10 times.

• The subquery is executed 10 times or maybe once, its values are stored in a hashjoin format, and the actual query reaches the hashjoin hashtable;
• When a query is submitted, it's not necessarily what is written which is executed. The Query Optimizer inspects the query and other relevant data to find the best way to get results.