- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Partition pruning to support more operators with list partitioning.
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.