Optimize query to minimize tmp copying time

Posted on

Question :

I have a query when Checking the profile i get this :

enter image description here

I read in order to optimize this i’ll have to work on my joins .

I also added index on the fields that i’m grouping by (date_seance , heure_debut) in the main table (seance_pratique)

enter image description here

Is there something i can do to make it faster ?

Update 1 (EXPLAIN QUERY):

enter image description here

Answer :

Review indexing on cours table as you’re getting a full table scan there.

http://mysql.rjweb.org/doc.php/ricksrots

Great indexing tips there ^

Leave a Reply

Your email address will not be published. Required fields are marked *