Hello experts,
Recently, we've been encountering poor query plans on our database workload.
We've successfully diagnosed the cause as reaching the default limit of 8
for join_collapse_limit.
We've already dealt with the situation successfully. However, I've been
discussing with some colleagues th
On 10/27/25 19:17, Carlo Sganzerla wrote:
>
> I assume that the reason why the hierarchical "tree join" is much faster
> is due to the dependencies among tables, so the standard join search has
> a much narrower range of possible query paths compared to the OLTP Star
> Join case. What surprised me
