Re: Storage of Foreign Keys

On Monday 21 September 2009, Christian Koetschan
<c.koetschan@biozentrum.uni-wuerzburg.de> wrote:
> Is everything I insert into mycolA and mycolB stored twice, or
> is there something like a pointer/reference from mycolA to the things
> stored in mycolB?
>

It's stored twice and for performance you need to index it in both tables.
If you put ON UPDATE CASCADE on it, an update to the master will hit both
tables though.

--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."