Which four types of column filtering may benefit from partition pruning when accessing tables via
partitioned indexes?
A.
Equality operates on List-Partitioned Indexes
B.
Not Equal operates on a Global Hash-Partitioned Indexes
C.
Equality operates on System-Partitioned Tables
D.
In-List operates on Range-Partitioned Indexes
E.
Not Equal operates on a local Hash-Partitioned Indexes
F.
Equality operates on Range-Partitioned Indexes
G.
Equality operates on Hash-Partitioned Indexes
Explanation:
Oracle Database prunes partitions when you use range, LIKE, equality (A, F), and
IN-list (D) predicates on the range or list partitioning columns, and when you use equality (G) and
IN-list predicates on the hash partitioning columns.
Reference: Oracle Database VLDB and Partitioning Guide 11g, Information that can be Used for
Partition Pruning
Agree with given answers
Agree too with answers