title: How can I see the SQL execution plan in Oracle?
body: <p>I'm learning about database indexes right now, and I'm trying to understand the efficiency of using them.</p>
  
  <ul>
  <li>I'd like to see whether a specific query uses an index. </li>
  <li>I want to actually see the difference between executing the query using an index and without using the index (so I want to see the execution plan for my query).</li>
  </ul>
  
  <p>I am using <strong>sql+</strong>. </p>
  
  <p>How do I see the execution plan and where can I found in it the information telling me whether my index was used or not?</p>