Thanks a lot for your very informative answer Richard, it's really helpful to know when writing queries!
It seems this is a case where some optimizations might be implemented? (I'm afraid this isn't something I could contribute though, sorry) Best, -- Elie
