Sergey,
I make 3 index but Vfp don't want optimze my requery.
Why ?
SYS(3054,11,"coptimation")
SELECT DatesFiltred.nposcat, ;
Etats.ccat_physiq ,;
Etats.nType , ;
COUNT( DatesFiltred.ddate ) AS "Ncat" , ;
Etats.ltransfert ;
FROM DatesFiltred ,Etats;
WHER DatesFiltred.nposcat = Etats.nposcat AND DatesFiltred.nType = Etats.nType AND ;
DatesFiltred.ddate BETWEEN Etats.ddebut AND Etats.dfin ;
ORDER BY ltransfert , DatesFiltred.nType , DatesFiltred.nposcat ;
GROUP BY ltransfert , DatesFiltred.nType , DatesFiltred.nposcat ;
INTO CURSOR Sum_Categ_per_periode
SYS(3054,0)
Rushmore optimization level for intermediate result: none
Rushmore optimization level for table etats: none
Joining table etats and intermediate result using temp index
>>Sergey,
>>
>>Look Message #
818705>>
>>Bernhrat
>>
>Hi Bernhart,
>
>I don't see anything interesting in that mesage besides incorrect statement that BETWEEN isn't Rushmore optimizable. In fact it is.