none
What potential performance bottlenecks can you observe? How would you avoid them?

    Question

  • select

        extract(hour from loan_time), count(*), sum(cents_loaned/100),

        sum(count(*)) over (order by extract(hour from loan_time)),

        sum(sum(cents_loaned/100)) over (order by extract(hour from loan_time)),

        min(loan_time), max(loan_time)

      from tbl_loans

        where loan_time::date = '2012-10-01'

          group by extract(hour from loan_time)

          order by extract(hour from loan_time)

    Saturday, December 07, 2013 10:16 AM

Answers

All replies