🚀 go-pugleaf

I have the following query, that takes 6..8 seconds on a large (4000 records 
in stoc_temporar) database. Is there a way to speed up this ?


Thank you in advance,

Tiberiu


select
   sum(stoc_temporar.stoc) as stoc,
   produse.denumire
from produse
  inner join stoc_temporar on (stoc_temporar.id_produs=produse.id_produs)
where
   produse.id_sortiment=3 and
   stoc_temporar.id_gestiune=1
group by
      produse.denumire
order by
      produse.denumire


PLAN JOIN (PRODUSE ORDER DENUMIRE_IDX INDEX (FK_PRODUSE_REFERENCE_SORTIMEN), 
STOC_TEMPORAR INDEX (FK_STOC_TEM_REFERENCE_PRODUSE, 
FK_STOC_TEM_REFERENCE_GESTIUNE)):
PLAN JOIN (PRODUSE ORDER DENUMIRE_IDX INDEX (FK_PRODUSE_REFERENCE_SORTIMEN), 
STOC_TEMPORAR INDEX (FK_STOC_TEM_REFERENCE_PRODUSE, 
FK_STOC_TEM_REFERENCE_GESTIUNE))

Adapted plan:
PLAN JOIN (PRODUSE ORDER DENUMIRE_IDX INDEX (FK_PRODUSE_REFERENCE_SORTIMEN), 
STOC_TEMPORAR INDEX (FK_STOC_TEM_REFERENCE_PRODUSE, 
FK_STOC_TEM_REFERENCE_GESTIUNE))