Hi,
Some of the techniques for achieving optimization query are normalization, ER diagram. Can someone let me know some more techniques to achieve query optimization and also let me know the scenario or when to use the same.

Regards,
Joel