Original link: Query Optimization Techniques - Tips For Writing Efficient And Faster SQL Queries / Jean HABIMANA.
I saw it referenced on LinkedIn. Short but good.