Risks on performance or table growth when adding null columns to very intensive and numerous rows ta
Hello,
I am in deadline urgent demand to add few columns ( Alter table add column with null values ) on very long table ( number of rows over 5 000 000 ) and with very long rowsize.
What risks should I manage in degeneration of table physical organization or index physical organization that could have impact on
performance or optimizer behaviour when adding the columns.
What about considering the options of
reorganization of tables with export/import, recreating the indexes, or table partioning?
I am in deadline urgent demand to add few columns ( Alter table add column with null values ) on very long table ( number of rows over 5 000 000 ) and with very long rowsize.
What risks should I manage in degeneration of table physical organization or index physical organization that could have impact on
performance or optimizer behaviour when adding the columns.
What about considering the options of
reorganization of tables with export/import, recreating the indexes, or table partioning?
0