Check out a free preview of the full SQL Fundamentals course:
The "Add Indices Exercise" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:
When asking our database to explain the work required to perform JOIN queries, developers can quickly recognize that some well-placed indices should be able to improve performance. In this exercise, students create a new DB migration that adds these new indices to a database's schema.