Database Tuning (MOSC)

MOSC Banner

Best approach to merging two tables together (one really big, one really small)

edited Jan 20, 2011 6:52AM in Database Tuning (MOSC) 3 commentsAnswered
We have a situation where we have a large fact table (approximately 1 billion rows, partitioned) that represents a sort of "baseline" set of data. We have another fact table with the same structure that collects "adjustments" to this same data. For business reasons, we need to keep them separate.

The "adjustment" table is very small, roughly 50k rows and each row in this table essentially replaces exactly one of the rows in the larger table. Also, in some cases we can have rows in the adjustment table for which there is no corresponding rows in the baseline. Obviously, the reverse of that is also true, most baseline rows are NOT adjusted.

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