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

    Unanswered: 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

  4. #4
    Join Date
    Jul 2014
    Posts
    1
    Quote Originally Posted by dbasaravanan View Post
    how many rows do you want to process in this query
    I would rather suggest to revisit the schema as its multiple joins and intersects and orderby above that in the query, it will indeed take time if the system memory is not configured correctly.

  5. #5
    Join Date
    Sep 2016
    Posts
    1
    This is very hard query plz help me to understand it first.what should i learn to solve it??

Posting Permissions

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