2 Replies Latest reply on Apr 21, 2014 1:56 PM by user5716448

    Performance of analytic functions versus outer-joins




      We have two options to give us the data



      data from transactional table.


      sum(sum(sales)) partition by (customer_num, issue_num)

      sum(sum(credits)) partition by (customer_num, issue_num)


      + potentially another 4 columns




      an outer join to another summary table


      customer_id = summary_table.customer_id

      and product_id = summary_table.product_id(+)


      Using oracle data warehouse - various  other dimension objects also included.


      Any thought son what will perform better  - outer joins versus analytic functions - suspect the outer join