Jeswanth Jaishanker (7/14/2010)
Dear Stephen,How does this improve the query speed when the previous 3 hour sql and current 15 seconds sql actually querying different tables and views?
Wondering why your team waited till UAT to find this very visible issue :hehe:.
In actuality, it was the perception that changed. My boss just moved the poorly performing query to what we call in the US "garbage time".
Why did we wait until UAT to find this problem? That's a very good question, one that I couldn't have answered at the time, let alone 12 years later.
Another point I want to make is that you can't assume in your development estimates that there won't be silly problems like this occurring at the worst possible time.