partition pruning eliminates index partitions even when table partitions are used in the query. There are two types of pruning–static or dynamic pruning. While static pruning occurs at query compiling ...