At 12:33 2013-05-07, "Gary Jeurink" <[email protected]> wrote:
I have a football game database that I manage by date. This required me to
make a table of dates to pull up the matching football games. ESPN seems to
group their games into a season_by_week and I like it.
Is it practical to just add a field to the game table like seasonWK (char-7)
resulting in. '2013_05' and even 2013_PS' to lump the post season games
together, and then the season and week of the game can be handled by 1 field
or should season and week be separate fields and use a compound index to
organize. In the same sense, I could eliminate the already existing field
season.
Combining data items into one column makes it awkward if you
have to separate them out for processing. If they are truly separate
items conceptually, keep them that way in the implementation.
There is nothing wrong with compound indexes.
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
