Multiple choice technology performance

Which of the following can be used as first steps to tune SQL Statements

  1. Explain Plan

  2. Trace

  3. Parse

  4. Bind

Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

Explain Plan and Trace are the correct first steps for SQL tuning. Explain Plan shows the execution plan and access paths. Trace provides detailed execution statistics. Parse and Bind are execution phases, not tuning tools - they describe how SQL is processed, not how to analyze or improve it.