O meu amigo...agrdeceria muutio se voce conseguisse me ajudar...vou postar aqui abaixo o txt para vc dar uma analisada..
99.999 - Razão de Clientes e Fornecedores VZ (Colig.: 1 / Cod.Aplic.: F)
[CP ]
select
master.CIDADE,
master.CGC,
master.NUMERO,
master.NOME,
master.RUA,
t0a1.IMAGEM,
master.CODCOLIGADA p1_2_n
from GCOLIGADA master (NOLOCK)
left outer join GIMAGEM t0a1 (NOLOCK) on ((master.IDIMAGEM=t0a1.ID))
where
(
master.CODCOLIGADA = 1
)
[LD 01]
select
t0a1.NOME,
master.QUANDOGEROU,
master.SALDO,
master.TIPOREGISTRO,
master.CODCFO p2_4_s,
master.CODCOLCFO p1_4_n
from FRAZAO master (NOLOCK)
left outer join FCFO t0a1 (NOLOCK) on ((master.CODCOLCFO=t0a1.CODCOLIGADA) and (master.CODCFO=t0a1.CODCFO))
where
(
((master.CODCOLIGADA=:p1_2_n)))
and (
(master.QUANDOGEROU = '39665,6168411806')
and ((master.TIPOREGISTRO >= 0) and (master.TIPOREGISTRO <= 1))
)
order by
t0a1.NOME ASC
[LD 01.01]
select
t1a1.IDLAN,
t1a1.DATARAZAO,
t1a1.RAZAOINCLUSAO,
t1a1.RAZAOBAIXA,
t1a1.QUANDOGEROU,
t1a1.SALDO,
t1a1.TIPOREGISTRO,
master.CODCFO,
t1a2.STATUSLAN,
t1a2.IDBAIXAPARCIAL,
t2a2.IDLAN
from FCFO master (NOLOCK)
left outer join FRAZAO t1a1 (NOLOCK) on ((master.CODCOLIGADA=t1a1.CODCOLCFO) and (master.CODCFO=t1a1.CODCFO))
left outer join FLAN t1a2 (NOLOCK) on ((t1a1.CODCOLIGADA=t1a2.CODCOLIGADA) and (t1a1.IDLAN=t1a2.IDLAN))
left outer join TPAGTO t2a1 (NOLOCK) on ((master.CODCOLIGADA=t2a1.CODCOLCFO) and (master.CODCFO=t2a1.CODCFO))
left outer join FLAN t2a2 (NOLOCK) on ((t2a1.IDLAN=t2a2.IDLAN) and (t2a1.CODCOLIGADA=t2a2.CODCOLIGADA))
where
(
((master.CODCOLIGADA=:p1_4_n) and
(master.CODCFO=:p2_4_s)))
and (
t1a2.STATUSLAN <> 1
and (t1a1.QUANDOGEROU = '39665,6168411806')
and ((t1a1.TIPOREGISTRO >= 2) and (t1a1.TIPOREGISTRO <= 3))
)
------------------------------
TOTAL.............. 00:01:09 100.0%
------------------------------
Consulta SQL....... 00:00:55 79.7%
Gerador............ 00:00:14 20.3%