Aging and Foreign Keys

Tables that are related by foreign keys must have the same aging policy.

• If LRU aging is in effect and a row in a child table is recently accessed, then neither the parent row nor the child row is deleted.

• If time-based aging is in effect and a row in a parent table is a candidate for aging out, then the parent row and all of its children are deleted.

• If a table has ON DELETE CASCADE enabled, the setting is ignored.