Entries from The Data Warehouse Insider tagged with 'Partitioning'

Partitioning or Backup Tables...?

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...

Partitioning and/or/with Exadata?

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)....

Compressing Individual Partitions in the warehouse

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...