SQL Language (MOSC)

MOSC Banner

Updating a Table

edited Nov 9, 2012 5:49AM in SQL Language (MOSC) 11 commentsAnswered ✓
Hi,

oracle DB : Release 11.2.0.3.0

We have  tables with around 220 columns,450 million records and we have to add three new columns.We have to  update them with the same value for each column. We can not use DEFAULT while adding the column as the tables are compressed. We have indexes on the tables as well. We will analyse the tables before starting the addition and updation of columns.

I want to know how the updation can be faster and as it is taking around 8Hrs. Will analysing the table after addition of column give any significant advantage over anaysing the table before addition? Also making a index with the new columns will help to update it faster?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center