Returning same row n amount of times. - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Returning same row n amount of times.

  1. #11
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You might also try recreating the "fifteen" table as an IOT and analyzing it, which would probably be the practice if it were implemented ... my local results (10g)
    Code:
    union all dual     11
    table of integers  13 (heap table)
    collection type    9
    table function     25
    pipelined function 17
    group by cube      1743
    ... and ...
    Code:
    union all dual     11
    table of integers  8 (analyzed IOT)
    collection type    8
    table function     20
    pipelined function 12
    group by cube      1702
    I also tried a hint-less version of all the queries, and got ...
    Code:
    union all dual     8
    table of integers  7
    collection type    7
    table function     20
    pipelined function 14
    group by cube      1717
    The Union-all seems to benefit there.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  2. #12
    Join Date
    Jan 2004
    Posts
    162
    So much for hints then :-(

    Thanks for suggestions Dave, good stuff.

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