Hi,
I am trying to add some more information to the table which already
has a lot a data (like 2-3000 records). The new information may be
adding 2-3 new columns worth. Now my questions are:
(1)Is it a good idea to add new columns to the existing table? then it
will create these new columns for all old records, will it not result
in wasting a lot of space??
(2)Is it a good idea to create a new table with the new information
and have as a forign key the index value from the first table?
There may be answers to these questions already in some threads but
since I dont have much time I thought I will post it again, if these
are already answered by someone could someone point me there? any help
would be appreciated, thanks,
raj.

Just add the columns. Yes you could add another table, but, unless
the normalization rules require it, don't. Speed is more important
than space. Empty text fields take little space in any event.

Good luck
Ira Solomon


IOn 11 Feb 2004 11:05:08 -0800, envynr (AT) yahoo (DOT) com (Raj) wrote:

Thanks for replying..
So, even if the table has more than 40 columns already and also lots
of data(like 3-4000 records) do you still feel adding more columns to
the same table is a good idea than adding a whole new table??
Sorry if my questions are of basic type, I dont have a very structure
background in databases, could you point me to some usefull
information in this regard??
Thanks,
Raj.


Ira Solomon <isolomon (AT) solomonltd (DOT) com> wrote