Depends on the underlying database, and you'd have to test your query to have any level of certainty.

That being said, query planning is generally where Oracle/MSSQl outshine MySQL/Postgres, especially for pruning unnecessary joins. BigQuery is great at it IME.