Querying partitioned tables efficiently

Published: 01 September 2021
on channel: SQL and Database explained!
10,009
114

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


Watch video Querying partitioned tables efficiently online without registration, duration hours minute second in high quality. This video was added by user SQL and Database explained! 01 September 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 10,009 once and liked it 114 people.