Let us assume that I create the following index on one of my tables.
I know (at least I think I do ) that the index will be used when I execute the following query.Code:CREATE INDEX added ON table ( date_field )
My question is this. Will the index be used when I execute the following query?Code:DELETE FROM table WHERE date_field = CURDATE()
Yours, Erik.Code:DELETE FROM table WHERE date_field < DATE_SUB(CURDATE(), INTERVAL 14 DAY)