Urh Srecnikblog.srecnik.info·Oct 13, 2024Reading Execution PlansI routinely do a "rehearsal" of my presentations with our DBA team and any other willing participants (they tend to be developers) to receive feedback and to share knowledge. In the last one, I've got quite an interesting question, which requires und...60 readsOracle Database
Muhammad Sherifmuhammad-sherif.hashnode.dev·Jan 18, 2024Query Execution Part 2: Join Algorithms - Hash JoinIntroduction This article offers an insightful exploration into the inner workings of the Hash join algorithm, explain it's two types one-phass and two-phase hash join, understanding its components in query plans. It delves into a detailed cost analy...6 likes·472 readshash join