title: How to use Oracle Indexes
body: <p>I am a PHP developer with little Oracle experience who is tasked to work with an Oracle database.</p>
  
  <p>The first thing I have noticed is that the tables don't seem to have an auto number index as I am used to seeing in MySQL. Instead they seem to create an index out of two fields.</p>
  
  <p>For example I noticed that one of the indexes is a combination of a Date Field and foreign key ID field. The Date field seems to store the entire date and timestamp so the combination is fairly unique.</p>
  
  <p>If the index name was PLAYER_TABLE_IDX how would I go about using this index in my PHP code?</p>
  
  <p>I want to reference a unique record by this index (rather than using two AND clauses in the WHERE portion of my SQL query)</p>
  
  <p>Any advice Oracle/PHP gurus?</p>