Hi all,

How can i improve a requery ?


(Sample)
LOCAL dvstart,;
dvend


dvstart = DATE() - 6000
dvend = DATE() + 12000

Table1
NAME C(18)
dstart D(8)
dEnd D(8)


Table2 && Many Records
ddate D(8) && Unique dates
Categorie C(1)


A = SECONDS()

Select COUNT(Temp2.Categorie ) FROM Table1,Table2 WHERE BETW(  Table2.ddate  , dvstart , dvend ) AND;
BETW( Table2.ddate , Table1.dStart , Table2.dEnd )= .T;
ORDER By Temp2.Categorie GROUP By Categorie Into Cursor Temp

B=SECONDS()
WAIT WINDOW NOWAIT TRANSFORM( B - A , "9999.99999")

It 's slow !

What can i do ?

Index on DTOS(dstart) and DTOS(dend) and Dtos(ddate) don't improve.

bernhart