Query optimization

Question

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...

 

 

Thanks in advance