All Forums Database
02 Sep 2016
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.
 

AtardecerR0j0 71 posts Joined 09/12
02 Sep 2016

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

Be More!!

You must sign in to leave a comment.