Calisto Zuzarte gave a great presentation on writing SQL for performance at the IDUG 2018 North America conference. Check it out at https://youtu.be/wUkEZy7D1V0