Forum Stats

  • 3,824,841 Users
  • 2,260,429 Discussions


Partition pruning to support more operators with list partitioning.

user3897193 Member Posts: 16 Blue Ribbon
edited Nov 26, 2019 9:33AM in Database Ideas - Ideas

According to manuals "Oracle Database prunes partitions when you use range, LIKE, equality, and IN-list predicates on the range or list partitioning columns, and when you use equality and IN-list predicates on the hash partitioning columns."

However partition pruning does not support e.g. NOT IN operator.

Oracle 12.2 database is having new feature where table can be list partitioned by multiple columns or by automatic list partitioning. These data structures would benefit greatly if one could exclude partitions by having NOT IN operator to do partition pruning.

Sven W.
1 votes

Active · Last Updated