ALTER STATEMENT - IF THE TABLE HAVE MORE THAN ONE BILLION RECORDS

Database

ALTER STATEMENT - IF THE TABLE HAVE MORE THAN ONE BILLION RECORDS

Hi,

I am Altering the table for addition of new columns. And tables is having more than 1 billion records.

Please let us know is it standard to alter the table with more than one billion records or not. Also guide us in best practise to alter the table with data.

1 REPLY
Teradata Employee

Re: ALTER STATEMENT - IF THE TABLE HAVE MORE THAN ONE BILLION RECORDS

You can have a look to the DNOETH's blog. It's very interesting

http://developer.teradata.com/blog/dnoeth/2013/08/why-dont-you-use-alter-table-to-alter-a-table