Get the latest tech news

The strange case of the underestimated Merge Join node


Brest, France, 12 January 2026 We recently encountered a strange optimizer behaviour, reported by one of our customers: Customer: “Hi Dalibo, we have a query that is very slow on the first execution after a batch process, and then very fast. We initially suspected a caching effect, but then we noticed that the execution plan was different.” Dalibo: “That’s a common issue.

None

Get the Android app

Or read this on Hacker News

Read more on:

Photo of strange case

strange case

Photo of Merge Join

Merge Join

Related news:

News photo

The Strange Case of the Rogue HP-12c Calculator