1 2 Previous Next 15 Replies Latest reply: Feb 6, 2013 6:51 AM by Nikolay Savvinov Go to original post RSS
      • 15. Re: Query Tuning:
        Nikolay Savvinov
        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