Oracle partition execution plan

Oracle partition execution plan range partitions available operations: www.2cto.com partition table, by n1, n2 partition range single: access a single partition range iterator: Access Multiple partitions partition range inlist: the partition key uses in for example: where n1 in (X1, X2) and n2 = X3partition range all: all partitions partition range empty: condition does not exist in the partition (or data cannot be found) partition range or: The partition key uses or such as where n1 = X1 or n2 = X2partition range subquery: partition range join-filter: partition range multi-column: available operation for hash partitions: partition hash single: partition hash iterator: partition hash inlistpartition hash allpartition hash subquerypartition hash join-filter has fewer partition range or and partition range multi-column list partitions than range: partition list singlepartition list iteratorpartition list inlistpartition list allpartition list emptypartition list orpartition list subquerypartition list join-filter