Multiple choice technology databases

What can be used to optimize the performance of simple SQL?

  1. DYNAMIC PARALLELISM

  2. HINTS

  3. STORED OUTLINES

  4. ALL
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Oracle SQL performance tuning can leverage hints to direct the optimizer, stored outlines to stabilize execution plans, and dynamic parallelism to speed up execution. Because all three techniques are valid methods to optimize simple or complex SQL statements, the choice containing all options is correct.

Keep practicing — related questions