Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: interval
Interval versus Range partitions
One of the nice things about partitioning in the database is that partition pruning can quickly eliminate the requirement to read large amounts of data when the partitioning key(s) are appropriately provided in your queries (and DML). This also extends to queries where the…
Interval partitioning just got better
Interval partitioning was a great feature when it arrived in version 11, because we no longer had to worry so much about ensuring partitions were available for new data when it arrived. Partitions would just be created on the fly as required. I’m not…
