Partition pruning is the method that the optimizer uses to to exclude partitions from the results of a query. See http://otn.oracle.com/docs/products/...part.htm#98260 for details.