[firebase-br] Select lenta! sera q preciso usar plan? nunca usei

[Joao Luiz]

Alexandre Villaça wrote:

> select
>   c.cd_linha, sum(b.vl_pedido)*sum(b.qt_pedido) "total"
> from
>   nota a left join
>   notaitem b on (a.cd_empresa=b.cd_empresa and
> a.cd_filial=b.cd_filial and a.sr_nota=b.sr_nota and
> a.nr_nota=b.nr_nota) left join   prodlinh c on
> (b.nr_referencia=c.nr_referencia) where
>   a.dt_emissao between '12/01/2005' and '12/31/2005'
>   and a.cd_empresa=1
>   and a.cd_filial=2
> group by 1

Show de bola, instantaneo!! 6000 linhas acessadas!!!!!!
Valeu pela valiosa dica, joins explicitos :)

--