SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
An online community of DBAs, developers and data intelligence builders, with videos, articles, resources and online events for members and non-members.
Find out more >>
(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.