DeanDing
New Contributor II

This fully depends on the table size and business logic, every case are different. For example, you don’t want to do left join when right table is way smaller than left one.