I came across suggestion that I should never use "USE INDEX" to tell MySQL which index to use. An expert said I should leave the decision to optimizer. That probably means I should just create indexes on columns that are most needed and not worry about it anymore. It would be really good if I can do that and rely on optimizer.
What do you think about that? Any pitfalls?
Aucun commentaire:
Enregistrer un commentaire