2.4. Indexing Foreign Keys

Some databases, for instance Oracle and Postgres, do not automatically create an index for each foreign key. This can result in deadlocks occurring. To avoid this situation it is necessary to create indexes on some of the columns that are referenced in foreign key constraints.

Indexes should be created on the following columns to avoid possible deadlocks and improve query performance: