Cartesian Join

Cartesian Join – the usual suspect (part2)

2025-01-13

Analysis of costing of joins in 10053, Cartesian Join, CBO 10053 trace, Hash Join, Nested Loop, Oracle SQL optimization, Performance Tuning, Sort Merge Join

Oracle Blog

Analysis of joins with 10053 CBO trace This post continues from Part 1, diving deeper into the challenges posed by a suboptimal SQL query that led the optimizer to select a Cartesian Join combined with an overly expensive Hash Join.But do not treat its content as limited to just a Cartesian Join.It will also help…
Cartesian Join – the usual suspect (part1)

2025-01-05

cardinality, Cartesian Join, CBO costing, Hash Join, optimizer, SQL Plan

Oracle Blog

Cartesian Join & Hash Join – Bonnie and Clyde “This movie is based on true story” Some time ago, I was approached to provide a solution to a performance issue.To illustrate this case, I will later simulate the scenario highlighting the critical aspects and providing a detailed explanation of the underlying causes.For now, let me…