11gR2 Interval Partitioning Pruning
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