Overview Today many developers try to optimizing query in order to get high performance of the application. I had a chance to optimize many queries…