Why is my HASH JOIN broken?

A hash join is often the most optimal way to perform a join, but sometimes the database will use a merge join no matter how hard to try to tell it otherwise. The two most common mistakes that will "break" your hash joins are nulls and data types.

Follow me!
blog: https://connor-mcdonald.com
twitter: https://twitter.com/connor_mc_d

The Podcast!
https://podcasts.apple.com/au/podcast/the-spoken-nerd/id1552316025
https://open.spotify.com/show/5dqVVftZhw0lu1fnX20TiP

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

#oracle #sql #datatypes

Видео Why is my HASH JOIN broken? канала SQL and Database explained!