This chapter will take you through query and schema tuning. The database is meant for the execution of queries; making it run faster is the end goal of tuning. The database's performance depends on many factors, mainly queries, schema, configuration settings, and hardware.
In this chapter, we are going to take the employees database to explain all the examples. You might have transformed the employees database in many ways in the preceding chapters. It is recommended to load the sample employees data again before trying the examples mentioned in this chapter. You can refer to Section Loading sample data in Chapter 2 to know how to load sample data.