Subject Re: Database Design Issue
Author Svein Erling

Read Anns reply to "Getting garbage info from the database" (two
messages before your question), where she advices to use triggers
rather than foreign keys.


> Will these foreign keys automatically generate indexes for these
> fields. If yes, these indexes are low selectivity - lots of
> duplicates.
> I always heard from the forum that low selectivity will slow down
> the performance of the table.
> How to resolve or maybe I should not enforce the foreign keys.