Subject Database Design Issue
Author chee hee
Hi All,

FB1.5 RC7 Embed

I have a main table with fields like sex, occupation, model, etc (around 10 of these fields) referencing parent tables respectively. Foreign keys are in placed for these fields. The table will contain millions of records.

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.



Download Yahoo! Messenger now for a chance to WIN Robbie Williams "Live At Knebworth DVD"

[Non-text portions of this message have been removed]