Querying partitioned tables efficiently
Perhaps the most attractive benefit of partitioning is that performance improvements that can be achieved when querying partitioned tables. Partition pruning is the term used to describe when the predicates of a query are such that the entire table does not need to be scanned, but only a subset of the partitions.
Follow me!
blog: https://connor-mcdonald.com
twitter: / connor_mc_d
Full playlist: • An introduction to Partitioning for ...
The Podcast!
https://podcasts.apple.com/au/podcast...
https://open.spotify.com/show/5dqVVft...
Subscribe for new tech videos every week
Other social media channels here: https://linktr.ee/connor
A free Oracle database forever ?! Oh yes indeed!
https://www.oracle.com/cloud/free
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla, Bensounds
#oracle #partitioning