Hi,

I've a master and a detail table.

the masters table PK is MASTER_ID

and the details tables has a FK
CONSTRAINT FK_MASTER_ID FOREIGN KEY(MASTER_ID) REFERENCES MASTER
(MASTER_ID)

The PK will never change, because of surrogate keys.

should I use
ON UPDATE NO ACTION
or
ON UPDATE CASCADE

Is the database faster with ON UPDATE NO ACTION, or isn't there any
difference in performance, with the point of view that the MASTER_ID never
change?

Regards,
Jörg Schiemann