Community

Unindexed Foreign Keys in Oracle and PostgreSQL

(Franck Pachot) In Oracle we need to have a index on the foreign key column as soon as we have the intention to delete from the parent row, or a locking situation may block all transactions around the child table.




Tags: