O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Introduction

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required