1 2 Previous Next 15 Replies Latest reply on Feb 6, 2013 12:51 PM by Nikolay Savvinov Go to original post
      • 15. Re: Query Tuning:
        Nikolay Savvinov

        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,
        1 2 Previous Next