🚀 go-pugleaf

OK, I'll guess - try to remove the use of the id_gestuine index like 
this (assuming that is the least selective index):

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+0=1
group by
       produse.denumire
order by
       produse.denumire

HTH,
Set

Tiberiu Horvath wrote:
> 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))