It’s time to use our theories and start building practical SQL tuning solutions. This chapter starts with high-level applications and then drills down through databases and SQL statements, until we get to operations.
Before we start looking for opportunities to improve performance we all need to agree to do something: stop guessing. We should never have to guess what program is slow, what database is slow, what statement is slow, or what operation is slow. No matter what part of our technology stack we are investigating, there are multiple tools that can easily and precisely tell us what is ...
