What index would you recommend to create?

Question

MySQL

Hello!

There is a table that stores all the url paths on the site: There are



more than 40k
records. I am looking for the desired record with a query:

select * from path_urls where path = 'mgu' and model_type = 'App\\EducationalInstitution'

The request took 0.0478 seconds.

Please explain how to create indexes for these fields?

Answer 1

make sane value classifiers for path and model_type and a regular composite index on these two fields