From: mcstockX@Xenquery   
      
   depends on the version, depends on if you're concerned with performance or   
   concurrency   
      
   indexes on FKs can help join performance   
      
   until some release of 9i (don't remember which -- it might even be 10g, but   
   i know it's been discussed in these forums before) indexes on FKs were   
   necessary to minimize locks when a PK value was updated (but not necessarily   
   when other columns in the PK records where updated)   
      
   -- mcs   
      
      
   "Olivier Crèvecoeur"  wrote in message   
   news:brsfea$1eom@aix4.segi.ulg.ac.be...   
   | Hello,   
   |   
   | Excuse me for my poor english.   
   | I would kike know if create index on the foreign key it's necessary or if   
   | Oracle, are optimized for using foreign key whithout index.   
   |   
   | Best regards   
   |   
   | Olivier   
   |   
   |   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)