title: Query optimization: apply SELECT, PROJECT before JOIN
body: <p>I am learning about query optimization. In general, applying PROJECT and SELECT before JOIN will give you better performance. My question is:</p>
  
  <p>Are there any cases that applying SELECT operation before applying JOIN operation or applying PROJECT operation before applying JOIN operation will be better?</p>
  
  <p>Thanks for any response.</p>