set correct plan
-
What is COE.sql and How We can set Execution plan for any sql
Most of us face with similar issue on our SQL which are running on our databases. Sometimes some SQL could choose different plan and performance goes to worst. Normally with correct plan SQL took 5 min, but with wrong plan choose it took 20 minutes. In this article I am trying to explain how we Continue reading
