var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Summary Table applicable for this problem ?
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?
Article about summary tables:
Hope this helps,