Hi,

Please help simplify the below query to run faster.

select
B.T$orno,
E.T$mitm,
C.T$dsca,
C.T$citg,
A.T$prlc(1),
A.T$prmc(1),
A.T$proc(1),
D.T$dsca,
E.T$cwar,
B.T$tano
from
baan.tbptmm200710 A,
baan.tbptmm220710 B,
baan.ttcibd001710 C,
baan.ttcmcs062710 D,
baan.ttisfc001710 E
where
B.T$orno >= B.T$orno.f and
B.T$orno <= B.T$orno.t and

E.T$mitm >= E.T$mitm.f and
E.T$mitm <= E.T$mitm.t and

C.T$citg >= C.T$citg.f and
C.T$citg <= C.T$citg.t and

B.T$trdt >= B.T$trdt.f and
B.T$trdt <= B.T$trdt.t and

C.T$cpcl >= C.T$cpcl.f and
C.T$cpcl <= C.T$cpcl.t and

B.T$orno = E.T$pdno and
B.T$psqn = A.T$psqn and
B.T$trdt = A.T$trdt and
C.T$cpcl = D.T$cpcl and
E.T$mitm = C.T$item
order by
B.t$orno;

Thank You

Is this request related to MongoDB?

If yes, no worries. If no, please post in the proper part of the forum.

how many rows do you want to process in this query