11. A method for pruning partitions comprising: receiving a query statement comprising a filter predicate on a column of a first database table, the filter predicate comprising a value for the column; pruning a particular partition of a second database table from access paths for processing the query statement; wherein the column of the filter predicate is not a column of a partitioning key used for partitioning the second database table; and wherein the particular partition is identified as pruneable based at least on (a) aggregated zone map information associated with the particular partition and (b) the value for the column in the filter predicate.
11. A method for pruning partitions comprising: receiving a query statement comprising a filter predicate on a column of a first database table, the filter predicate comprising a value for the column; pruning a particular partition of a second database table from access paths for processing the query statement; wherein the column of the filter predicate is not a column of a partitioning key used for partitioning the second database table; and wherein the particular partition is identified as pruneable based at least on (a) aggregated zone map information associated with the particular partition and (b) the value for the column in the filter predicate. 13. The method of claim 11 , wherein the first database table and the second database table are the same table.