Database DataWarehousing (MOSC)

MOSC Banner

Approach to table partitioning process

edited Feb 20, 2011 11:48PM in Database DataWarehousing (MOSC) 7 commentsAnswered
Hello,
Have a nice and oxygenated day with a lot of sunshine and green juices.

I am trying to prepare some workflow list for table partitioning process.
We have few ultra tables with lot of rows and very long records.

We try to locate the most consuming SQL clauses which could be affected with partitioning.

We need those SQL clauses for testing on newer partition organization tables and also for setting up the process of logging of imrpovements in performance.

Our entry idea is to separate history data from the actual data.
History data is still needed but frequency of SQL demands are much much lower than SQL demands on actual 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