2 Replies Latest reply: Apr 21, 2014 8:56 AM by user5716448 RSS

    Performance of analytic functions versus outer-joins

    user5716448

      Hi,

       

      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

       

      versus

       

      an outer join to another summary table

       

      customer_id = summary_table.customer_id

      and product_id = summary_table.product_id(+)

       

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

       

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

       

      Thanks