🚀 go-pugleaf

Can you provide us the plan that is getting used? You can do this in 
isql with set plan on, or in IBConsole in the Plan tab.

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))
> 
> 
> 

-- 
CREATE DOMAIN NEW_COMPANY AS CHAR(8) DEFAULT 'CODEGEAR' CHECK (VALUE <> 
'BORLAND') NOT NULL;