PL/SQL (MOSC)

MOSC Banner

Upadate millions of rows

edited Nov 17, 2011 3:07AM in PL/SQL (MOSC) 6 commentsAnswered
Hello world,

One of my developer require to update 10 million rows form one of the table (Tab1). To select this rows we have to make query and compare with another table(tab2).

Tab1 has 32 Million rows and Tab2 has 10 million rows.

To just query ( list this rows or count ) it takes around 3.5- 4 hours.

What would be the best option to perform this operation?

Thanks

Dev

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