>I am trying to determine why my SQL statement is returning
>'Partial' Optimization instead of full.
>
>SELECT Acctnum, DeptNum;
> FROM Chg;
> WHERE Chg.Acctnum='5555555';
> INTO CURSOR cResult

Patrick, in my experiments with this very issue, I have found that the optimization will be "partial" if any of the fields in the select statement are not in an index. In your example, AcctNum is indexed, but the query processor still has to go back to the main table to retrieve DeptNum. That's why the optimization is partial. If the entire query can be resolved by the contents of the index, then optimization will be "full".

Like I said, this is my empirical observation only... I could certainly be wrong.