Re: Modeling and Normalizing
Posted by:
Rick James
Date: February 19, 2010 10:15AM
Multi-party was a wrinkle I did not know about. Sounds like you have a pretty good handle on it. So, it sounds like the vote-count table needs something like:
Candidate, Party, Race, Count
The first 3 would be the PRIMARY KEY. And you may want other indexes depending on the queries desired. (For example, an index starting with Race to show all the results for one race.)
Could the incumbent flag be moved into the Candidate table?
Your biggest table won't be more than a few thousand rows, right? In that case, performance will be fine, even if you are sloppy about indexes.
Subject
Written By
Posted
February 17, 2010 05:53PM
February 17, 2010 06:05PM
February 18, 2010 02:29PM
February 18, 2010 03:17PM
Re: Modeling and Normalizing
February 19, 2010 10:15AM
February 19, 2010 10:50AM
February 20, 2010 11:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.