Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    50

    Unanswered: Summary Table applicable for this problem ?

    Hi

    I have a table CONTRACT:
    CUSTOMER_ID, LOCATION, PREMIUM

    I have, let's say, 1.5 Mio Customers and 3.6 Mio premiums and 300 locations. I want to have a count(PREMIUM) for a LOCATION for just some CUSTOMER_ID's, NOT for all customers of a location.

    select LOCATION, sum(PREMIUM) from CONTRACT where CUSTOMER_ID in (select ID from ...) group by LOCATION.

    Can summary tables be used in such a case to increase performance?

    Marc

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Article about summary tables:
    http://www.devx.com/gethelpon/10Minu...16580/0/page/1

    Hope this helps,
    Grofaty

Posting Permissions

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