Database Administration (MOSC)

MOSC Banner

index rebuild to retain performance

edited Oct 1, 2012 12:05AM in Database Administration (MOSC) 7 commentsAnswered
Below is a scenario and request input on how to retain the current performance of the system.
With change in code that need to implemented in a production envrionment, an application gets a large response from an interacting device and as a result, the applicaion needs to populate 500 rows each in two tables Table1 and Table2 out of several other tables. The percentage increase in number of rows of Table1 is projected to be 150% while for the Table2, it is 50% (which translate to daily increase of 25 million rows from present 10 million rows for Table1 and increase of 43 million rows from present 28 million rows for Table2). There is a historical data

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