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.

I need to delete a number of rows from a table. Should I have indexing on for the columns that I'm using to choose what to delete?