DBAsupport.com Forums - Powered by vBulletin
Page 4 of 4 FirstFirst ... 234
Results 31 to 33 of 33
  1. #31
    Join Date
    Jun 2004
    Got it. Okay I ran bith with UNION and UNION ALL.

    With UNION:

    It ran the second query first, and then the first.
    Time it took: Elapsed: 00:00:14.94

    With UNION ALL:

    It ran the first query and then the second:
    Time it took: Elapsed: 00:00:14.06

    With my Select for the function
    Time it took: Elapsed: 00:00:14.50

    So, should I change my function to have UNION ALL, instead of using a cursor?

  2. #32
    Join Date
    May 2005
    So, should I change my function to have UNION ALL, instead of using a cursor?
    Follow Tom Kyte's Mantra http://asktom.oracle.com/pls/ask/f?p...:1205168148688 :

    o if you can do it in a single sql statement - do so.
    o if you cannot, do it in as little PLSQL as you can.
    o if you cannot, because plsql cannot do it, try some java (eg: sending an email
    with an attachment)
    o if you cannot do it in java (too slow, or you have some existing 3gl code
    already) do it in C as an extproc.
    Last edited by Bonker; 06-16-2005 at 11:32 AM.
    Experience is a hard teacher because she gives the test first, the lesson afterwards.

  3. #33
    Join Date
    Jun 2004
    I discern from his Mantra that I should use UNION ALL in my report, instead of nested table. I thought theier website went down. This new looks really cool. Thanks for helping.

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.