MySQL optimization key #2: Create the right indexes An index improves query performance by reducing the amount of data in the database that queries must scan.