The WITH (BUFFERING = .T.) clause requires SQL engine to perform additional work to account for buffered records. It causes queries become slower and partialy optimized.

>how i can optimize :
>
>WITH (BUFFERING = .T.)
>
>if i use select - Sql as below, this is optimization level : Partial
>
>

>local mymemvar
>=sys(3054,11,"mymemvar")
>SELECT qty,amt,plusminamt,Scheme,tdamt,cdamt,excise,taxamt,vatamt,octroi,freight,cnamt,Add,less,tbamt ;
>FROM inward1 with (buffering = .T.) WHERE reco1=lxreco1 INTO CURSOR tempinward1
>WAIT WINDOW mymemvar
>
>

>
>if i use select - Sql as below, this is optimization level : Full
>but not sum the buffered records.
>
>but i want to Sum buffered records also.
>
>

>local mymemvar
>=sys(3054,11,"mymemvar")
>SELECT qty,amt,plusminamt,Scheme,tdamt,cdamt,excise,taxamt,vatamt,octroi,freight,cnamt,Add,less,tbamt ;
>FROM inward1 wHERE reco1=lxreco1 INTO CURSOR tempinward1
>WAIT WINDOW mymemvar
>

>
>
>warm regards,
>mk.