Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2014
    Posts
    1

    Question Unanswered: Query Performance

    Hi Guys,
    i've write a bit complicated sql query.Its work file but my concern is would it cause any perfomance issue if executed with millions of records ? please advice.

    my sql look like below.

    select a,b,c,d,sum(e),sum(f)
    from
    (select A.*,case....,case ....
    from
    (Select xx.abc, xx.cdf , yy.ghi , ...
    from table12 xx table13 yy
    where xx.abc=yy.abc) A )
    group by a,b,c,d

    hope someone can advice me on this. thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Depending on what the ellipsis hides, there may or may not be a problem.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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