Introduction
– Game of Fixing Broken SQL
Think of tuning as a game: based on my own experiences over more than the past
decade:
•A SQL tuning specialist can tune much
more SQL than he or she can originate – tune other people’s SQL!
•You’ll know far less about the
application than the original SQL coder – they know the
purpose best!
•You could just focus on making
individual queries faster – just be a better optimizer than the
CBO.