Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Las Vegas, NV
    Posts
    1

    What is a better practice

    I need to add a text field to a table, but at most, only about 5% of the records in the table will ever use this text field, the rest will just hold a NULL value.

    My question is whether it would be better design or not to make another table for this text field with a 1-to-1 relationship to the existing table.

    Thanks a lot for you input,
    Greg

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: What is a better practice

    Originally posted by gvandora
    I need to add a text field to a table, but at most, only about 5% of the records in the table will ever use this text field, the rest will just hold a NULL value.

    My question is whether it would be better design or not to make another table for this text field with a 1-to-1 relationship to the existing table.

    Thanks a lot for you input,
    Greg
    A NULL column shouldn't occupy much space (if any) so there should be harm in having the column in the main table. In Oracle, if the column is at the end of the row it will take up NO space when empty.

Posting Permissions

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