This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Feb 6, 2013 4:51 AM by Nikolay Savvinov Go to original post RSS
  • 15. Re: Query Tuning:
    Nikolay Savvinov Guru
    Currently Being Moderated
    Hi,

    1) I'm proposing to run the subqueries separately as a test, not as a solution; I'm not exactly sure what your intention was, but you sounded like you were offering a solution
    2) I don't think that your code would work the way you intended because use of rownum is one of common obstacles in query transforms (in other words I'm not sure if Oracle would be able to transform a subquery containing rownum into a join), but making a test won't hurt

    Best regards,
    Nikolay
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points