Great, thanks @ms4446 

Hello @ms4446 ,Great insight for query optimization!However, I have one question regarding the use of joins and where clause in Bigquery.In above example of revised query you have used joins first and then where clause.Since we are only filtering on ...