Under chapter 7 , SUbquery formatting in MysQL , they have mentioned one guide to read for query optimization. Kindly link that guide.
