Don’t create indexes in every column. This slows things down on insert, delete or update operations.
You may create an index for columns that are common in WHERE
, ORDER BY
or GROUP BY
clauses. You may also consider adding an index in columns that are used to relate other tables JOIN
.
Index are best used for big domain fields such as ids, names, surnames. Don’t use them for male/female fields.
A good recommendation is to measure performance time before and after the creation of that index. If your index doesn’t improve performance remove it as it causes overhead.