In this chapter, you will learn how to estimate if our queries are under performing. It may well happen, and if this is the case, what are the rules to apply to improve them? The rule of thumb is to reduce the number of db hits.
A DB hit is a unit of work for the database. So, how do we do this?
We will cover the following topics in the chapter:
- Explain and profile instructions
- Query plan
- Rule of thumb for improving performance