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 'Best Practices'.