Subject | Re: How to make my report quicker |
---|---|
Author | heroes3lover |
Post date | 2007-05-27T23:29:58Z |
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:
result, seems like there is no obvious improvement after I add the
the index on sales date,
But still thanks.
Roc
<iblist@...> wrote:
>would
>
> Sean wrote:
> > I would create a compound index on StoreID + SalesDate -- this
> > narrow the range of your processing.storeid/plu/salesdate
> >
> >
> > 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
>on Sales Date
> My question is:
>
> Won't FB combine the PK index (for the StoredID) and a simple index
> to narrow down the result set as if there is a compound index on(StoreID, SalesDate) ?
>I just try in a smaller testing database, According to my testing
> 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
>
result, seems like there is no obvious improvement after I add the
the index on sales date,
But still thanks.
Roc