Apr 23: Indexes and Query Optimizer

Learning Objectives

After today's class, you should be able to:

• Explain how to create SQL indexes and analyze query performance.

Lesson Outline

• [30 min] Indexes and Query Optimizer

• [10 min] Submission of HW8

  • Create a github repository
  • Add me as a collaborator (userid: maerizvi)
  • Use Sample-HW8-repository as an example of the structure and report

• [25 min] Activity:

  • Create a new GitHub repo for HW8
  • Add me and all members of your group as collaborators
  • Copy the structure of the sample
  • Put your HW7 submission files in the repo

Your To-Do List

• Work on HW8