samedi 23 juillet 2016

MySQL should I ever use USE INDEX and when?

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