title: Oracle - How to obtain information on index fields etc
body: <p>How can I list indexes columns readily defined in Oracle?</p>
  
  <p>And how do I use those indexes in a select statement? Something like:</p>
  
  <pre><code>SELECT x, y, z FROM a WITH INDEX(x)...
  </code></pre>