Re: what is fastest way to add 4 columns to a 100 million row table

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sun, 13 May 2001 01:59:11 GMT
Message-ID: <3afde8e2.3060158@news-server>

On 12 May 2001 18:13:02 -0500, sdfes_at_dsf.com (sdfsd) wrote:

>we have a table 110 million rows, with 60 columns all not null. We need to
>add new 4 columns also not null but no data is avialable for the new
>columns they will become filled as time goes on.
>

Yeah, but is it the new rows where the new columns will become filled or is it for every single one of the 100Mrows? World of difference there!

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sat May 12 2001 - 20:59:11 CDT

This message: [ Message body ]
Next message: Hans Forbrich: "Re: what is fastest way to add 4 columns to a 100 million row table"
Previous message: sdfsd: "what is fastest way to add 4 columns to a 100 million row table"
In reply to: sdfsd: "what is fastest way to add 4 columns to a 100 million row table"
Next in thread: Hans Forbrich: "Re: what is fastest way to add 4 columns to a 100 million row table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US