PL/SQL (MOSC)

MOSC Banner

Updating 20 million rows

edited Sep 1, 2010 9:25AM in PL/SQL (MOSC) 12 commentsAnswered
Hi,

I need to update a table as follows:

Update table_a

set Column_1 = 99 where column_1 is null/ some other value

However, the table has 20 million rows. What is the best way to do this in the fastest possible manner??

The database version is 10gR2. The table is range partitioned on the date_key, with 1 month's record in 1 partition.

Please let me know if you need any more information.

Thanks in advance! 

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center