title: How to choose and optimize oracle indexes?
body: <p>I would like to know if there are general rules for creating an index or not.
  How do I choose which fields I should include in this index or when not to include them?</p>
  
  <p>I know its always depends on the environment and the amount of data, but I was wondering if we could make some globally accepted rules about making indexes in Oracle.</p>