Query optimization

Dec 24 2015 9:43 AM

What is Query Optimization?can any one explain with a realtime scenario please...

Please dont share the links..like theory Parts.Every one know the theory but we are expecting practical knowledge from this Site...