jaime,

this is the code.


SELECT Etats && Table1
INDEX ON ddebut TAG ddebut ADDITIVE
INDEX ON dfin TAG dfin ADDITIVE


SELECT * FROM datesParametres WHERE BETWEEN( datesParametres.ddate , D_debut , d_fin ) INTO CURSOR DatesFiltred && Table2

SELECT DatesFiltred
INDEX ON ddate TAG ddate ADDITIVE

SYS(3054,11,"coptimation")

SELECT DatesFiltred.nposcat, ;
Etats.ccat_physiq ,;
Etats.nType , ;
COUNT( DatesFiltred.ddate ) AS "Ncat" , ;
Etats.ltransfert ;
FROM DatesFiltred ;
INNER JOIN amline!Etats ON DatesFiltred.nposcat = Etats.nposcat AND DatesFiltred.nType = Etats.nType AND ;
DatesFiltred.ddate >= Etats.ddebut AND DatesFiltred.ddate <= 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)


CREATE CURSOR TT ( gmemo M )
INSERT INTO TT ( gmemo ) VALUE( coptimation )
CLEAR
? coptimation

Rushmore optimization level for intermediate result: none
Rushmore optimization level for table etats: none
Joining table etats and intermediate result using temp index



Why there is no optimisation ?

bernhart