Voina Blog (a tech warrior's blog) Using temporary indices to optimize DELETE operations on big tables in #DB2
DELETE operations are much faster in case we disable constraints. This is because not all foreign keys affected by the DELETE are indexed. We have to detect all the foreign keys that point to the t…
