>I wonder...
>
>In my project startup code, I have set optimize ON but in my forms datenevironment, it seems to fall to OFF. I put set optimize on into the beforeopentable method and it is faster.
>Is it a normal situation ?

Not normal. The VFP default is ON even in private data sessions. Are you using a form class that may have this in the from Load, Init or other method where it gets turned off? What about in a method of the DE?