How to make this query run faster

advidscontact's Avatar

advidscontact

09 Feb, 2017 11:12 AM

Hello,
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;

Please Help!
Thanks in advance

For more details check http://blog.advids.co/12-b2b-video-production-tips-to-drive-more-engagement

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

11 Apr, 2018 04:35 AM
10 Apr, 2018 04:19 PM
28 Mar, 2018 10:39 AM
15 Mar, 2018 08:23 AM
26 Feb, 2018 11:19 AM

 

07 Feb, 2018 02:33 AM
07 Feb, 2018 02:31 AM
07 Feb, 2018 02:30 AM
25 Jan, 2018 03:48 PM
12 Jan, 2018 02:45 PM
12 Jan, 2018 04:48 AM