Database DataWarehousing (MOSC)

MOSC Banner

11gR2 Interval Partitioning Pruning

edited Mar 29, 2017 11:21AM in Database DataWarehousing (MOSC) 12 comments

I am assessing the impact of redefining a 256GB table to be partitioned.  It was determined that partitioning on the DTE_PROCESS field would work.  Unfortunately, DTE_PROCESS is not a date, but a number in the form of YYYYMMDD.  Rather than define each partition, and create new ones for each month I thought I'd try interval partitioning.  To facilitate interval partitioning I had to create the DTE_MTH column as a function of DTE_PROCESS.  This worked well, and after the load I now have 11 partitions that show the proper high values.   I then started testing some queries against the table to

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