AIQB
TutorialsOrdinary

Your Agent's ADD FOREIGN KEY Stalls Writes on Two Tables. NOT VALID, Then VALIDATE

Source: DEV Community·

Summary

ADD FOREIGN KEY takes a write-blocking lock on both tables while it scans. Reproduce it in Docker, then split it into NOT VALID and VALIDATE.
TierOrdinary
Published
Indexed by AIQB
SourceDEV Community
AIQB record IDintel-9647dacfaee8c7afb2e28309