> The joins will be pruned by the query planner if they are not needed, so there is no need for conditional joins.
I always wondered about this. How reliable is that in your experience? Thank you in advance.
I always wondered about this. How reliable is that in your experience? Thank you in advance.
That being said, query planning is generally where Oracle/MSSQl outshine MySQL/Postgres, especially for pruning unnecessary joins. BigQuery is great at it IME.