If the SQL coder knows the codes purpose best, how can you find a functional
fix?
As a SQL tuning specialist, you see
much more SQL than an average coder you will
know SQL better than the average coder!
There are recurring patterns that
frequently point to functionally broken SQL, and you can
recognize these patterns even without knowing the
application, without knowing the detailed purpose of the SQL!