Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: Look-up Table Design

    What is the current thinking on best design for look-up tables in the database? I've been out of this loop for a while - when I did this last, the thinking was - create a single 'domain' table and populate it with all the lookup types and values. Is this still considered the best way to design look-ups?
    Thanks.

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    What sort of columns will the table have?

    If you have a few short columns then an index organised table is good for look ups.

    Rgs,
    Breen.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •