Local versus Global indexes on partitioned tables

Some people suggest that local indexes should always be used in preference to global indexes. This is not the case, and each indexing technique should be employed to best match the application requirements you have. A local index can be the absolutely wrong choice for particular kinds of queries


Follow me!
blog: https://connor-mcdonald.com
twitter: 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

• #science_technology
• #oracle
• #oracle_database
• #asktom
• #office_hours