Are the statistics wrong on your data? Or is it that the subqueries modify the data set such that the statistics are unknown for the outer query? Arbitrary ad

Are the statistics wrong on your data? Or is it that the subqueries modify the data set such that the statistics are unknown for the outer query? Arbitrary ad hoc query support is hard, it feels like you want indices on everything but then data insertion is dog slow. Then even with perfect stats I’ve seen vertica and PostgreSQL order aspects of queries wrong, I know the pain you speak of. I’ve not convinced myself that it’s always solvable or obvious until you do it wrong though, I never spent much time explaining queries before executing them or explaining “fast” queries though.