--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

>
>
> 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
>

I just try in a smaller testing database, According to my testing
result, seems like there is no obvious improvement after I add the
the index on sales date,
But still thanks.
Roc