PowerSchool Group Interview Question

Type of optimizer join,which one to use when