Which four types of column filtering may benefit from partition pruning when accessing tables via partitioned indexes?

Which four types of column filtering may benefit from partition pruning when accessing tables via
partitioned indexes?

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


vasya_pupkin

vasya_pupkin

Agree with given answers

raka

raka

Agree too with answers