Re: Index and foreign key

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" <Olivier.Crevecoeur_at_ulg.ac.be> wrote in message news:brsfea$1eom_at_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
|
|
Received on Thu Dec 18 2003 - 17:41:12 CET