Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2012
    Posts
    2

    How to make this query run faster

    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

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Is this request related to MongoDB?

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

  3. #3
    Join Date
    Aug 2011
    Posts
    1
    how many rows do you want to process in this query

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •