John,
You've got some good suggestions from Hilmar. Remove the ALLTRIM() from the query and from the index expressions. Also, how many records are returned if you remove the GROUP BY clause?

>Hi,
> my SQL
>
>

>SELECT Ino, bCode ;
>FROM Stock_Status ;
>WHERE ALLTRIM(UPPER(INO)) = "012" AND ALLTRIM(UPPER(BCODE)) = "AW" AND ;
>        ALLTRIM(UPPER(LOCCODE)) == "KL" ;
>GROUP BY INO,BCODE ;
>INTO CURSOR csrResult
>
>

>
>SYS(3054) show this query run with full optimized.
>
>Thnak you

Daniel