Oracle documentation:Partition Pruning and Partition-Wise Joins. You think not?Maybe, maybe not. Not every sql statement can take advantage of partition pruning.
my be says is different from suggest.
When to Partition a Table Here are some suggestions for when to partition a table: Tables greater than 2GB should always be considered for partitioning.