Subject Re: [firebird-support] Re: How to make my report quicker
Author Alexandre Benson Smith
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
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil