Nested Loop

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…