3 ms·

Oracle will also use partitioning optimizations in that case. See partition pruning[1]. [1] https://docs.oracle.com/en/database/oracle/oracle-database/12.2/vld

by miahi 6y ago

Oracle will also use partitioning optimizations in that case. See partition pruning[1]. [1] https://docs.oracle.com/en/database/oracle/oracle-database/12.2/vldbg/partition-pruning.html https://docs.oracle.com/en/database/oracle/oracle-database/1...

philliphaydon 6y ago
Awesome. Thanks for the info. I wasn’t sure if it was supported or not.