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 && CURSOR tempstat2

  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.