Hello
Excuse me first for my english .. but i wil try to speak correctly..
My SQL Statement is :
select
PR.plr_num,
PR.con_code,
ENC.enc_montant,
ENC.tpr_code,
PCE.dev_code,
PCE.pce_modif
from pl-rdv PR, encaisse ENC, piece PCE
where
(PR.plr_date_deb <= DATE(12,31,2002))
and (PR.plr_date_fin >= DATE(01,01,2002))
and (PR.age_code = 08)
and ENC.con_code = PR.con_code
and (PCE.pce_code = ENC.pce_code) and (PCE.tpr_code = ENC.tpr_code)
order by PR.plr_num.
The number of line returned is 36000 and the time is 170 sec.
I work under Progress 8.3B/HP-UX with ODBC v 3.50 ..
How can i improve this .. Help ??
Thank You...
Excuse me first for my english .. but i wil try to speak correctly..
My SQL Statement is :
select
PR.plr_num,
PR.con_code,
ENC.enc_montant,
ENC.tpr_code,
PCE.dev_code,
PCE.pce_modif
from pl-rdv PR, encaisse ENC, piece PCE
where
(PR.plr_date_deb <= DATE(12,31,2002))
and (PR.plr_date_fin >= DATE(01,01,2002))
and (PR.age_code = 08)
and ENC.con_code = PR.con_code
and (PCE.pce_code = ENC.pce_code) and (PCE.tpr_code = ENC.tpr_code)
order by PR.plr_num.
The number of line returned is 36000 and the time is 170 sec.
I work under Progress 8.3B/HP-UX with ODBC v 3.50 ..
How can i improve this .. Help ??
Thank You...