FK -> PK internal checks

Hi List

Let say I have a table with five foreign keys (not null columns) which point to 5 tables. When I insert a row into the table Oracle must check that there are corresponding values in the PKs/Unique Keys of these tables. How does Oracle perform this check? It's not recursive sql, is it? I'm interested in internals. Am I correct if I say that Oracle checks index entries for each PK's index until the first corresponding value is found? It seems it's worth enough (minimum 2 reads for each PK)

Am I on the right way?

Thanks in advance Received on Fri Oct 13 2000 - 09:24:06 CDT