Got this comment on the blog from Satish. Satish is proposing (or forced) to create backup tables instead of using partitioning. I'm not sure you want to go there. If you do, I think you will need to create views...
Got a little busy there with all the comments on the Netezza posting, but now we're back into some of the outstanding topics. This post is the next one on discussing some of the ODTUG session questions (see this post)....
Partitioning, now that is a topic that we talk a lot about here at Oracle. If you look in the data warehouse guide and related publications you will see lots on partition pruning, partition wise joins and partitioned indexing. For...
If you use an RSS reader, you can subscribe to a feed of all future entries tagged 'Partitioning'.