Database Reference
In-Depth Information
fields, indexes improve performances only when reading data using the
SELECT
command.Inthiscase,youaremakinganumberofupdatesonthetable(
INSERT
,
UPDATE
,and
DELETE
);dependingonthescenario,itcouldbelesstimeconsuming
to drop and recreate the index after the updates.