Sean wrote:

> I would create a compound index on StoreID + SalesDate -- this would
> narrow the range of your processing.
>
>
> Sean
>

Set wrote:

> Try creating another index (storeid, salesdate)

I wrote:

> Create another index on A.SalesDate

Heors2lover said that PK on table on Table PluWeek is storeid/plu/salesdate

My question is:

Won't FB combine the PK index (for the StoredID) and a simple index on Sales Date
to narrow down the result set as if there is a compound index on (StoreID, SalesDate) ?

To Heroes3Lover:
By the way, did you increase your performance with our suggestions ?


see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br