Show Table of Contents
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:
Human-Task schema:
- Task.processinstanceid
- task.processid
- task.status
- task.archived
- task.workitem
- i18ntext.language
Core engine schema:
- eventtables.instanceid
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.