I have 5 non clustered index(s) on each of the following columns in ASC order

customer_id varchar(13)

product_name varchar(256)

product_code char(10)

paid_amount(decimal(18,2)

date_of_sale(datetime)

I apologize! I forgot to include the query

QUERY

---------------------------------

SELECT distinct product_name AS ProductName,

(SELECT SUM(paid_amount)FROM transactions tr2 WHERE tr1.product_code = tr2.product_code) AS TotalPaidAmount,

(SELECT SUM(paid_amount) FROM transactions WHERE date_of_sale >= '2010-01-01' AND date_of_sale...

Thanks. That solves the facility part

What about groups in groups?

Thanks 4 the reply. I finally figured what my problem was. The remote client I was connecting from is behind a corporate firewall that doesn't allow outbound traffic on port...

Thanks 4 the reply. I finally figured what my problem was. The remote client I was connecting from is behind a corporate firewall that doesn't allow outbound traffic on port...